Behavior of nextval() and currval() - Mailing list pgsql-general

From Mike Mascari
Subject Behavior of nextval() and currval()
Date
Msg-id 3BF11280.DAAB8812@mascari.com
Whole thread Raw
Responses Re: Behavior of nextval() and currval()
Re: Behavior of nextval() and currval()
List pgsql-general
The following works in 7.1. Is this behavior guaranteed or is it the
subject of possible change in the future? Or am I just "getting
lucky" that nextval() is evaluated before currval():

CREATE SEQUENCE s;

CREATE TABLE test (
key1 int4,
key2 int4
);

INSERT INTO test
SELECT nextval('s'), currval('s');

SELECT * FROM test;

 key1 | key2
------+------
    1 |    1

Thanks for any information,

Mike Mascari
mascarm@mascari.com

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Is data storage secure?
Next
From: Marcelo Pereira
Date:
Subject: Create Table