nextval is a function found in postgres databases and is used to seed the
value of a serial(auto increment) that is normally used as a key.

other uses are select currval(serial) to get the current value and select
setval(serial,value) to set the vlaue on the fly.

much more info can be found in the postgresql docs at


"Ric Manalac" <[EMAIL PROTECTED]> wrote in message
> hello.
> i've seen DEFAULT NEXTVAL(serial) being used
> in some examples but i have not seen an explanation
> of what it exactly does. can anyone please explain
> what it is and how it can be used?
> i have some idea but i want to make sure by asking
> other people. thanks!
> ric
> --
> ==================================================================
> Note: The information contained in this message may be privileged
> and confidential and protected from disclosure. If the reader of
> this message is not the intended recipient,or an employee or agent
> responsible for delivering this to the intended recipient,you are
> hereby notified that any dissemination, distribution or copying of
> this communication is strictly prohibited. If you have received
> this communication in error, please notify us immediately by
> replying to the message and deleting it from your computer.
> Thank you.
> ==================================================================

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to