============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Nir Oren
Your email address : nir@global.co.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:
---------
--------------------------------------------------------------------------