Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2005-03-24 13:38:22
Subject: Re: cast not IMMUTABLE?
Previous:From: Enrico WeigeltDate: 2005-03-24 13:03:20
Subject: public key authentification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group