Horton

Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D

Craig Ringer <ringerc@ringerc.id.au>

View thread View on postgr.es
From: Craig Ringer <ringerc@ringerc.id.au>
To: Rodrigo Rosenfeld Rosas <rr.rosas@gmail.com>
Cc: Gavin Flower <GavinFlower@archidevsys.co.nz>, pgsql-sql@postgresql.org
Date: 2012-09-17T04:52:46Z
Lists: pgsql-sql 
On 09/13/2012 07:20 AM, Rodrigo Rosenfeld Rosas wrote:

> Thank you Gavin, I was looking for this LEAST function for a long time.
> I have tried MIN but it didn't work with strings.

In SQL, "MIN" is an aggregate function. It actually does work with 
strings, but only when used as an aggregate:

regress=# SELECT min(x.a) FROM ( VALUES ('blah'),('blah2'),('aaaa') ) x(a);
  min
------
  aaaa
(1 row)

--
Craig Ringer