pgsql: Fix AT TIME ZONE for timestamps without time zones: test=>

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix AT TIME ZONE for timestamps without time zones: test=>
Date: 2005-07-22 21:16:15
Message-ID: 20050722211615.93F7B52A25@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix AT TIME ZONE for timestamps without time zones:

test=> select ('2005-07-20 00:00:00'::timestamp without time zone) at
time zone 'Europe/Paris';
timezone
------------------------
2005-07-19 22:00:00-04

Udpate documentation.

Modified Files:
--------------
pgsql/doc/src/sgml:
func.sgml (r1.268 -> r1.269)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.268&r2=1.269)
pgsql/src/backend/utils/adt:
timestamp.c (r1.141 -> r1.142)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.141&r2=1.142)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2005-07-22 21:18:18 Re: pgsql: Fix AT TIME ZONE for timestamps without time
Previous Message Tom Lane 2005-07-22 19:55:51 pgsql: Fix insufficient check for overflow in tm2abstime(), per report