Re: creating "job numbers" - Mailing list pgsql-sql

From jdassen@cistron.nl (J.H.M. Dassen (Ray))
Subject Re: creating "job numbers"
Date
Msg-id slrn9bk07e.v22.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to creating "job numbers"  ("postgresql" <pgsql@symcom.com>)
List pgsql-sql
postgresql <pgsql@symcom.com> wrote:
>I can not first ask with the number will be, and asking for the previous
>oid after  the fact can also lead to  the same problem.

If you use sequences and the currval() and nextval() functions, you can. See
e.g. http://www.postgresql.org/docs/aw_pgsql_book/node85.html .

HTH,
Ray
-- 
"a infinite number of monkeys typing into GNU emacs would never make a good
program".../linux/Documentation/CodingStyle



pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: creating "job numbers"
Next
From: Andrew Perrin
Date:
Subject: Re: creating "job numbers"