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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
