Re: [GENERAL] Revisiting UPDATE FROM ... ORDER BY not respected

2011-04-12 Thread Carlo Stonebanks
s.pgh.pa.us] Sent: April 12, 2011 8:15 PM To: Carlo Stonebanks Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Revisiting UPDATE FROM ... ORDER BY not respected Carlo Stonebanks writes: > A few years ago I asked about creating a single UPDATE statement to assign > id's from a sequenc

Re: [GENERAL] Revisiting UPDATE FROM ... ORDER BY not respected

2011-04-12 Thread Tom Lane
Carlo Stonebanks writes: > A few years ago I asked about creating a single UPDATE statement to assign > id's from a sequence, with the sequences applied in a particular order. In > other words, order the table, then apply nextval-generated id's to the id > field in question. > Here is the original