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

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


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