Re: Order by, expressions & column aliases issue

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