On Fri, Sep 2, 2016 at 10:10 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > 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.
I didn't miss it, I just never thought that anyone would care about a secondary sort key if the primary sort key was random. I have trouble imagining a use-case for that. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers