On Jan 7, 2008, at 4:43 PM, Scott Marlowe wrote:
On Jan 7, 2008 4:38 PM, Josh Williams <[EMAIL PROTECTED]> wrote:
On Mon, 2008-01-07 at 17:03 -0500, Emi Lu wrote:
select ?max?(col1, col2, col3) as result;
will return
result
-------
5
8
12
(3 rows)
8.1 (I believe?) introduced GREATEST(), which does precisely what
you're
looking for.
How would greatest give him three rows like that? Maybe I'm
misunderstanding what the OP was asking for...
His test data was:
col1 col2 col3
----------------------
1 5 2
8 1 3
12 1 1
So, SELECT test(col1, col2, col3);
returning
test
-----
5
8
12
Is giving the max of the three columns for each row.
Erik Jones
DBA | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
