> > As far as I can tell, Postgres has no equivalent to greatest and least
> > functions in Oracle.
> Doesn't max/min() do that ? Note that I know nothing about
> greatest/least in Oracle.
No, max/min are aggregate functions. Greatest allows you to select
the largest of a series of terms.
Here's a simple example:
greatest(1,2,3,4,5,6) would return 6
Here's a bit more useful one:
greatest(field1,field2,field3) would return the largest value from the
three supplied fields from the current row.
Writing a case statement to select the largest from among 3 or more
values gets a bit complicated.
--
Mike Nolan