Port Bug Report: 'today'::datetime <> datetime('today'::date)

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Anto Prijosoesilo
Your email address    : antop@netscape.net

Category        : runtime: back-end: SQL
Severity        : serious

Summary: 'today'::datetime <> datetime('today'::date)

System Configuration
--------------------
  Operating System   : FreeBSD 2.2.8-RELEASE

  PostgreSQL version : 6.4

  Compiler used      : gcc 2.7.2.1

Hardware:
---------
FreeBSD test.inet.co.th 2.2.8-RELEASE FreeBSD 2.2.8-RELEASE #0: Wed Dec  9 12:25:50 ICT 1998
root@test.inet.co.th:/usr/src/sys/compile/TEST i386  

Versions of other tools:
------------------------
gmake 3.77

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

Problem Description:
--------------------
The output of select 'today'::datetime does not match
the output of datetime('today'::date) except when
the backend is run with TZ=GMT

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

Test Case:
----------
Start postmaster with TZ != GMT
psql -c "select 'today'::datetime,datetime('today'::date)" template1


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

Solution:
---------


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