Jan Wieck <janwi...@yahoo.com> writes: > Note that PL/pgSQL replaces all local variables inside a query with > $-parameters for the prepared SPI plan. The parser rejects ordering by > non-integer constants, but it does not reject ordering by $-parameters > or constant expressions. (maybe it should).
The only real reason it complains about simple constants is that otherwise people might think "ORDER BY 1" means something different than what it does mean according to SQL92. Otherwise, if you want to sort by a constant, who are we to stop you? regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs