Re: [GENERAL] timestamp with timezone and time zone name

2012-08-08 Thread Steve Crawford
On 08/07/2012 08:36 PM, Shridhar Daithankar wrote: On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote: > Shridhar Daithankar writes: > > I am wondering, why following two values result in a shift by 3.5 hours. I > > would expect them to be identical. > > > > I understand that canonical ti

Re: [GENERAL] timestamp with timezone and time zone name

2012-08-07 Thread Shridhar Daithankar
On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote: > Shridhar Daithankar writes: > > I am wondering, why following two values result in a shift by 3.5 hours. I > > would expect them to be identical. > > > > I understand that canonical time zone names could be ambiguous at times > > but I think IS

Re: [GENERAL] timestamp with timezone and time zone name

2012-08-06 Thread Tom Lane
Shridhar Daithankar writes: > I am wondering, why following two values result in a shift by 3.5 hours. I > would expect them to be identical. > I understand that canonical time zone names could be ambiguous at times but I > think IST is not one of them. I don't know why you'd think that ... sr

[GENERAL] timestamp with timezone and time zone name

2012-08-06 Thread Shridhar Daithankar
Hello, I am wondering, why following two values result in a shift by 3.5 hours. I would expect them to be identical. I understand that canonical time zone names could be ambiguous at times but I think IST is not one of them. Any explanation? --- test=# select '2012-08-07 05:24:56.