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

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