Postgres Pro
Downloads
Home   >   mailing lists

Re: TIME ZONE SQL - Mailing list pgsql-sql

From Richard Huxton
Subject Re: TIME ZONE SQL
Date
Msg-id 200402042003.07189.dev@archonet.com
Whole thread Raw
In response to TIME ZONE SQL  ("Raman" <ramang@smartdatainc.com>)
List pgsql-sql
Tree view 
On Wednesday 04 February 2004 17:57, Raman wrote:
>
> This query runs fine when i have
> time_difference value like +5:30 +5:00 i.e. works fine for positive values
> but failes for negative values i.e. -7:00, -6:00 etc
>
> I don't know WHY WHY... pls help
> I am helpless.

Can you give example outputs? It's difficult to decide otherwise.
--  Richard Huxton Archonet Ltd

pgsql-sql by date:

Previous
From: "Raman"
Date:
Subject: TIME ZONE SQL
Next
From: "Richard Sydney-Smith"
Date:
Subject: Slow sub-selects, max and count(*)