Re: cast not IMMUTABLE?

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cast not IMMUTABLE?
Date: 2005-03-24 13:15:52
Message-ID: 20050324131552.GB19555@nibiru.borg.metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> > why that cast is not considered IMMUTABLE ?
>
> Because it depends on your TimeZone setting. Observe:

BTW: whats really the difference between timezone and
timezonetz ? I always used to use timestamp (w/o tz) and
thought timestamptz was just an question of presentation.

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service

phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
-- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
---------------------------------------------------------------------

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-24 13:38:22 Re: cast not IMMUTABLE?
Previous Message Enrico Weigelt 2005-03-24 13:03:20 public key authentification

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-03-24 13:38:22 Re: cast not IMMUTABLE?
Previous Message Neil Conway 2005-03-24 12:35:35 Re: more detailed timing ?