Re: creating "job numbers"

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: creating "job numbers"
Date: 2001-03-22 13:41:02
Message-ID: slrn9bk07e.v22.jdassen@odin.cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

postgresql <pgsql(at)symcom(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-03-22 13:59:48 Re: creating "job numbers"
Previous Message Andrew Perrin 2001-03-22 13:36:56 Re: creating "job numbers"