Re: How do I get the rec-id from an insert.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Thu, Aug 29, 2002 at 15:00:15 -0600,
  Clinton Adams <clinton@xxxxxxxxxxxxxx> wrote:
> Chris -
> 
> You don't really need to know the key values - make it one query:
> 
> insert into c values (nextval('crecid'), currval('arecid'), currval('brecid'))

Is it documented that the above is reliable? I don't remember ever reading
that expressions are evaluated in the order they appear in a select
statement.


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux