On 18 Apr 2009, at 22:22, Tom Lane wrote:
This is mentioned in the release notes, but I suppose we'd better
promote it to the "observe the following incompatibilities" list...
This is a really funny one, because people naturally expect UNION
[ALL] to stay in the same order. Unlike the table, order here cannot
change by inserts/updates, etc.
I am sure many, even well experienced will stumble upon that one.
Me is guessing, that UNION [ALL] performance just had to be improved
for CTEs ? Or was it something completely separate.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers