On Tue, Jul 01, 2003 at 12:29:16 -0400,
Greg Stark <gsstark(at)mit(dot)edu> wrote:
>
> SELECT greatest(a,b) FROM bar
>
> would return one tuple for every record in the table with a single value
> representing the greater of bar.a and bar.b.
You can do this with case.
SELECT CASE WHEN a >= b THEN a ELSE b END FROM bar;