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

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

Your name : Anto Prijosoesilo
Your email address : antop(at)netscape(dot)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(at)test(dot)inet(dot)co(dot)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:
---------

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