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

Поиск
Список
Период
Сортировка
Искать

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

От:
momjian@svr1.postgresql.org (Bruce Momjian)
Дата:
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)

Re: pgsql: Fix AT TIME ZONE for timestamps without time

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

Nope, I now see it still is not fixed.  Working now.

---------------------------------------------------------------------------

Bruce Momjian wrote:
> 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)
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
FAQ