VALUES() evaluation order - Mailing list pgsql-general

From Steve Atkins
Subject VALUES() evaluation order
Date
Msg-id 5D5660F3-58EB-493B-91BB-27E7FB4DCE5A@blighty.com
Whole thread Raw
Responses Re: VALUES() evaluation order  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Is the order in which the expressions in a VALUES() clause defined?

I'm doing this: INSERT INTO foo (a, b) VALUES (nextval('bar'), currval('bar'))

It works fine, but I'm wondering whether it's guaranteed to work or whether I'm relying on an artifact of the
implementation.

Cheers,
  Steve



pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: 9.2 upgrade glitch with search_path
Next
From: Tom Lane
Date:
Subject: Re: VALUES() evaluation order