Re: subtract a day from the NOW function - Mailing list pgsql-sql

From Tom Lane
Subject Re: subtract a day from the NOW function
Date
Msg-id 29828.1181254100@sss.pgh.pa.us
Whole thread Raw
In response to Re: subtract a day from the NOW function  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-sql
Steve Crawford <scrawford@pinpointresearch.com> writes:
> But PG doesn't follow the same rules in subtracting timestamptz values
> so operations involving timestamps and intervals are (sometimes) not
> reversible:

Yeah.  timestamp_mi is performing a justify_hours call, which it should
not, but removing that call changes a lot of the regression test
outputs.  So we've been afraid to change it.  You can find more about
that in the archives.
        regards, tom lane


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: subtract a day from the NOW function
Next
From: osmar della paschoa jr
Date:
Subject: Re: [ADMIN] the right time to vacuum database?