Re: [HACKERS] Allow ORDER BY a Function

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: daveh(at)insightdist(dot)com (David Hartwig)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Allow ORDER BY a Function
Date: 1998-11-21 20:10:49
Message-ID: 199811212010.PAA01883@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Updated.

> Bruce,
>
> Small correction to the TODO list. The "allow ORDER BY a function"
> feature already exist in 6.4.
>
> EXAMPLES:
>
> SELECT foo FROM bar ORDER BY upper(foo);
>
> -- or any other expression for that matter
>
> SELECT foo FROM bar ORDER BY att1 || att2;
>
> It was done as part of the "allow GROUP BY a function" feature.
>
>
>

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-11-22 05:49:57 Re: [HACKERS] Bug in 6.4 release
Previous Message Hui Chun Kit, Jacky 1998-11-21 19:46:27 Questions on using multi-byte character in a field of a table (BIG5)