| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | Michael Glaesemann <grzm(at)seespotcode(dot)net>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, "Campbell, Lance" <lance(at)uiuc(dot)edu>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: subtract a day from the NOW function |
| Date: | 2007-06-07 22:08:20 |
| Message-ID: | 29828.1181254100@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Steve Crawford <scrawford(at)pinpointresearch(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Pavlov | 2007-06-07 22:21:14 | Re: index vs. seq scan choice? |
| Previous Message | Joshua D. Drake | 2007-06-07 22:01:51 | Re: index vs. seq scan choice? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | osmar della paschoa jr | 2007-06-08 00:59:04 | Re: [ADMIN] the right time to vacuum database? |
| Previous Message | Michael Glaesemann | 2007-06-07 21:58:03 | Re: subtract a day from the NOW function |