Re: [SQL] getting back autonumber just inserted

2005-07-09 Thread Mischa Sandberg
Quoting "jimmy.olsen" <[EMAIL PROTECTED]>: > I don't know how to create a Global Variable in Postgres, but the > idea is > very simple: > 1. Encapsulate the NextVal function in MyNextVal > 2. Set to Global variable with NextVal of the desired sequence > 3. Inspect to value of the global variable (

Re: [SQL] getting back autonumber just inserted

2005-07-09 Thread jimmy.olsen
I don't know how to create a Global Variable in Postgres, but the idea is very simple: 1. Encapsulate the NextVal function in MyNextVal 2. Set to Global variable with NextVal of the desired sequence 3. Inspect to value of the global variable (exactally as it's done in MsSQL) When Creating a Table: