From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Exclusion constraints with time expressions |
Date: | 2012-11-18 01:41:12 |
Message-ID: | k89ebo$3r8$2@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2012-11-06, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> hari(dot)fuchs(at)gmail(dot)com wrote:
>> > I think the problem is that this + operator is implemented
>> > by the function "timestamptz_pl_interval", which is STABLE
>> > but not IMMUTABLE.
>> >
>> > I am not sure why this function cannot be IMMUTABLE, it
>> > seems to me that it should be.
>>
>> No: the result of e.g.
>>
>> SELECT TIMESTAMPTZ '2012-10-28 01:30:00' + INTERVAL '24 hours';
>>
>> depends on the client's timezone and its DST rules.
>
> You are right; timestamptz_in itself is STABLE, and I forgot
> about daylight savings time.
The original poster had a timestamptz constant (using the naval
timezone 'Z') yet he still had the problem.,
--
⚂⚃ 100% natural
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2012-11-18 01:43:07 | Re: Difference between varchar and text? |
Previous Message | David Johnston | 2012-11-18 01:37:34 | Re: Difference between varchar and text? |