Allow ORDER BY a Function

From: David Hartwig <daveh(at)insightdist(dot)com>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Allow ORDER BY a Function
Date: 1998-11-21 18:36:23
Message-ID: 36570827.51D2EDF7@insightdist.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1998-11-21 18:46:06 Re: [HACKERS] Problem with 6.3.2
Previous Message Hui Chun Kit, Jacky 1998-11-21 18:32:33 Questions on using multi-byte character in a field of a table (BIG5)