Kevin Grittner <kgri...@gmail.com> writes:
> On Fri, Sep 2, 2016 at 9:51 AM, Tom Lane <t...@sss.pgh.pa.us> wrote:
>> regression=# select *, generate_series(1,3) from int8_tbl;
> I'm sure that you realize that running a query of that form twice
> against a table with more than one heap page could result in rows
> in a different order, even if no changes had been made to the
> database (including no vacuum activity, auto- or otherwise).
You missed my point: they might complain about the generate_series
output not being in the order they expect, independently of what
the table rows are.
Also, before getting too high and mighty with users who expect
"select * from table" to produce rows in a predictable order,
you should reflect on the number of places in our regression
tests that assume exactly that ...
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
