On Jan 7, 2008 4:38 PM, Josh Williams <joshwilliams(at)ij(dot)net> 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...