Allow ORDER BY a Function
David Hartwig <daveh@insightdist.com>
From: David Hartwig <daveh@insightdist.com>
To: Bruce Momjian <maillist@candle.pha.pa.us>, pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 1998-11-21T18:36:23Z
Lists: pgsql-hackers
Bruce,
Small correction to the TODO list. The "allow ORDER BY a function"
feature already exist in 6.4.
EXAMPLES:
SELECT foo FROM bar ORDER BY upper(foo);
-- or any other expression for that matter
SELECT foo FROM bar ORDER BY att1 || att2;
It was done as part of the "allow GROUP BY a function" feature.