Thread: Stored procedure for generation next sequence value

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

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/

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