Stored procedure for generation next sequence value

On Oct 29, 2007, at 18:59 , Frank Church wrote:

Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?

http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.2
http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html

Michael Glaesemann
grzm seespotcode net

On Mon, 29 Oct 2007 23:59:59 +0000
"Frank Church" <voipfc@googlemail.com> wrote:

Is there a built in function for retrieving the next value of a
sequence and updating the sequence counter?

The docs are amazing:

http://www.postgresql.org/docs/current/static/functions-sequence.html

Sincerely,

Joshua D. Drake

---------------------------(end of
broadcast)--------------------------- TIP 3: Have you checked our
extensive FAQ?

http://www.postgresql.org/docs/faq

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/