[vox-tech] Postgres Oracle Compatibility - serial column type

Jay Strauss vox-tech@lists.lugod.org
Fri, 25 Jan 2002 13:31:20 -0600


The later,

But many times one will put a trigger (on insert) on the table to
automatically set the value

Jay
----- Original Message -----
From: "Eric Engelhard" <eric_cl@pacbell.net>
To: "vox-tech" <vox-tech@lists.lugod.org>
Sent: Friday, January 25, 2002 1:13 PM
Subject: [vox-tech] Postgres Oracle Compatibility - serial column type


> Keywords: postgres, oracle, RDBMS computability issues
>
> I'm trying to anticipate scripting computability issues for Postgres and
> Oracle. I have already migrated from Perl Pg to Perl DBI, but there are
> also RDBMS function issues to consider. Does anyone know whether Oracle
> has a data (column) type equivalent to Postgres SERIAL, or does one have
> to create a sequence and use nextval()/currval()/setval()?
>
> --
> Eric Engelhard
> _______________________________________________
> vox-tech mailing list
> vox-tech@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com