Hussein Patni <[EMAIL PROTECTED]> writes:
> It seems subraction of an interval from a
> timestamptz is not immutable. Should this be the case?
Yes, because the results depend on your local timezone. For example:
regression=# set TimeZone TO 'EST5EDT';
SET
regression=# select '2005-02-28 17:00-0
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I was trying to create a functional index on a timestamptz column and
had the following problem. It seems subraction of an interval from a
timestamptz is not immutable. Should this be the case?
foo=> create table timestamp_tz_test ( start tim