Bug #656: timestamp function generates parsing errors when used as specified in the documentation

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #656: timestamp function generates parsing errors when used as specified in the documentation
Date: 2002-05-03 05:24:26
Message-ID: 20020503052426.B1EAD475A72@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Bron Gondwana (brong(at)h-r-s(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
timestamp function generates parsing errors when used as specified in the documentation

Long Description
See the following session examples using the form given in the documentation. 'select timestamp(now());' fails similarly.

All systems are running Debian GNU/Linux 3.0.

... I have a pile of scripts that use the timestamp function to convert incoming date-times for comparison. This breaking without
the change being documented is causing major headaches here!

I will be reverting to 7.1.3 in the short term.

Sample Code
... Three different machines.
a) luet running 7.1.3 on i386
b) grendel running 7.2.1 on i386
c) golgotha running 7.2.1 on sparc

a)
brong(at)luet~>echo "select timestamp(date '2000-12-25');" | psql template1
timestamp
------------------------
2000-12-25 00:00:00+11
(1 row)

b)
brong(at)grendel~>echo "select timestamp(date '2000-12-25');" | psql template1
ERROR: parser: parse error at or near "date"

c)
brong(at)golgotha~>echo "select timestamp(date '2000-12-25');" | psql template1
ERROR: parser: parse error at or near "date"

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-05-03 05:38:52 Re: Bug #656: timestamp function generates parsing errors when used as specified in the documentation
Previous Message pgsql-bugs 2002-05-02 16:53:45 Bug #655: win32 client and bytea column