Re: ORDER BY vs. volatile functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ORDER BY vs. volatile functions
Date
Msg-id 2654.1258350240@sss.pgh.pa.us
Whole thread Raw
In response to ORDER BY vs. volatile functions  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: ORDER BY vs. volatile functions
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> This query:
> select random() from generate_series(1,10) order by random();
> produces sorted output.
> Should it?

It always has; we'd doubtless break some apps if we changed that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: limit to default display in psql
Next
From: Itagaki Takahiro
Date:
Subject: Re: proposal: using PQexecParams in psql (using variables as real params)