Search Postgresql Archives

Re: target list evaluation wrt sequences

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

 



On Sat, Apr 24, 2004 at 04:03:24PM -0700, elein wrote:

> insert into ...
> 	select
> 		nextval('n') as a,
> 		currval('n') as b,
> 		...
> 	from lalala
> ;
> 
> Is the order of the target list guaranteed?
> That is, will the a and b in the above selection
> *always* be the same?  

No, it is not guaranteed to be the same.

PS: did you get my previous emails?  I sent #70 to you, and a lot of
questions ...

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux