Re: max (timestamp,timestamp)

On Mon, Nov 13, 2006 at 07:29:09PM +0500, imad wrote:
> max (timestamptz, timestamptz) does not exist already. You need to
> create a simple function in PLpgSQL something like
> 
> if a > b
> return a;
> else
> return b;

Since PostgreSQL 8.1 you can use GREATEST:

test=> SELECT greatest(1, 2);greatest 
----------       2
(1 row)

test=> SELECT greatest(2, 1);greatest 
----------       2
(1 row)

test=> SELECT greatest(6, 3, 1, 10, 9, 5, 2, 7, 8, 4);greatest 
----------      10
(1 row)

-- 
Michael Fuhr