> > 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.
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2004-08-22 17:37:29|
|Subject: Re: About inheritance |
|Previous:||From: Joe Conway||Date: 2004-08-22 17:32:32|
|Subject: Re: Greatest/Least functions?|