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