Port Bug Report: date<'abstimevalue+TIMEZONE' fails

============================================================================
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:
---------

--------------------------------------------------------------------------