Jeff Trout wrote:
This isn't terribly clear in the documentation.
But it seems, in 8.0.3 and 8.1.1 that you cannot use a column alias in
an order by if you are using an expression (ie order by
my_column_alias <> 0 asc). If you use a plain asc/desc order by then
it is fine (ie order by my_column_alias asc).
Yah - I ran into this a few months ago. Here's Tom's comments:
http://archives.postgresql.org/pgsql-general/2005-10/msg00208.php
- John Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
