Re: Ordering 'A', 'B', ..., 'Z', 'AA', 'AB', ... - Mailing list pgsql-general

pgman wrote:
> > ORDER BY
> >     CASE WHEN TABLE.MYCOLUMN LIKE '__'
> >          THEN TABLE.MYCOLUMN
> >          ELSE ' ' || TABLE.MYCOLUMN END
> >
> > The syntax may be a little different in pg, though.
> >
> > It's also easy enough to do in Perl with a custom sort sub.
>
> In PostgreSQL, you would need to create a column with the CASE, the
> order by that using the column number or AS to name the column and order
> on that name.

Sorry, I was wrong.  You can use CASE in ORDER BY.  I made a mistake in
my quick testing.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026