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