Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding 1 week to a timestamp, which can be NULL or expired - Mailing list pgsql-general

From John R Pierce
Subject Re: Adding 1 week to a timestamp, which can be NULL or expired
Date
Msg-id 4EC8D8AC.1080908@hogranch.com
Whole thread Raw
In response to Adding 1 week to a timestamp, which can be NULL or expired  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view 
On 11/20/11 2:32 AM, Alexander Farber wrote:
>     update pref_users set vip = max(vip, now()) + interval '1 week';
>
> but max() doesn't work with timestamps.

max works fine with timestamps... however, its a 1 argument function
that takes an aggregate as its argument.

you perhaps want GREATEST(val1,val2)

update pref_users set vip = greatest(vip, now()) + interval '1 week';



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Adding 1 week to a timestamp, which can be NULL or expired
Next
From: Marko Kreen
Date:
Subject: Re: Installed. Now what?