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
