Re: max (timestamp,timestamp)

Michael Fuhr wrote:
> 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);

That'll be a handy feature! Unfortunately, my server is still on 7.4.


Thanks to everyone for the quick responses.
-- 


Regards,

Tarlika