pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Michael Glaesemann <grzm@seespotcode.net>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: subtract a day from the NOW function
Date: Thu, 07 Jun 2007 18:08:20 -0400
Message-ID: <29828.1181254100@sss.pgh.pa.us> (raw)
In-Reply-To: <46687395.80707@pinpointresearch.com>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E24@SAB-DC1.sab.uiuc.edu>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E25@SAB-DC1.sab.uiuc.edu>
	<9938A77A-6E63-413D-8AC9-7CB741D075E6@seespotcode.net>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E27@SAB-DC1.sab.uiuc.edu>
	<46684A70.4080903@g2switchworks.com>
	<4668555E.20003@pinpointresearch.com>
	<D3436F83-5008-4CA3-B056-E792654B4F73@seespotcode.net>
	<46687395.80707@pinpointresearch.com>

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



view thread (19+ messages)  latest in thread

Message-ID: <29828.1181254100@sss.pgh.pa.us>
Permalink:  ../29828.1181254100@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/29828.1181254100@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, scrawford@pinpointresearch.com, grzm@seespotcode.net, smarlowe@g2switchworks.com, lance@uiuc.edu
  Subject: Re: subtract a day from the NOW function
  In-Reply-To: <29828.1181254100@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox