Re: [BUGS] problem creating rtree index on timestamptz

2005-02-28 Thread Tom Lane
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

[BUGS] problem creating rtree index on timestamptz

2005-02-28 Thread Hussein Patni
-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