From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | Port Bug Report: date<'abstimevalue+TIMEZONE' fails |
Date: | 1999-03-17 17:32:49 |
Message-ID: | 199903171732.MAA95294@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Nir Oren
Your email address : nir(at)global(dot)co(dot)za
Category : unknown
Severity : non-critical
Summary: date<'abstimevalue+TIMEZONE' fails
System Configuration
--------------------
Operating System : Linux 2.0.34 ELF (Redhat 5.1)
PostgreSQL version : 6.4.2
Compiler used : egcs???
Hardware:
---------
P200 64Mb, uname:Linux hecate.neuralware.co.za 2.0.34 #1 Fri May 8 16:05:57 EDT 1998 i586 unknown
Versions of other tools:
------------------------
not sure, std redhat stuff
--------------------------------------------------------------------------
Problem Description:
--------------------
let abstime be a abstime type together with a timezone (SAST)
The following works: select * from mytable where datetime<abstime
however select * from mytable where datetime>abstime
fails if the timezone is included, without the timezone, it works
--------------------------------------------------------------------------
Test Case:
----------
As described above,
SELECT * from mytable WHERE time<'Wed Mar 17 18:55:19 1999 SAST'
works
SELECT * from mytable WHERE time>'Wed Mar 17 18:55:19 1999 SAST'
returns no results, but
SELECT * from mytable WHERE time>'Wed Mar 17 18:55:19 1999'
does work
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Quoc Le | 1999-03-18 20:01:43 | unixware 7 port |
Previous Message | Torrez | 1999-03-17 10:41:36 | test |