Re: Theory ques: To autogenerate PK or not???????

"Pierre G. Boutquin" wrote:
>
> <jasondma_at_my-deja.com> wrote in message news:8s4lo0$iuk$1_at_nnrp1.deja.com...
> > I have been pondering the question of whether or not to autogenerate
> > Primary keys or manage them using a key table for some time and I have
> > not been able to come to a satisfactory conclusion.
>
> MSSQL has _at__at_IDENTITY that solves the problem. I suspect other RDBMs have
> something similar, though I have *NO* experience whatsoever with PostgreSQL.

ASA and probably also ASE (since both MSSQL and ASA have it) also use _at__at_identity. Just do a "select @@identity" after the insert and it gives you the last auto incremented value.

hth,
Heinz Received on Fri Oct 13 2000 - 07:45:25 CEST