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