Re: postgresql 7.2b4 bug - Mailing list pgsql-hackers

From Tom Lane
Subject Re: postgresql 7.2b4 bug
Date
Msg-id 22609.1010509552@sss.pgh.pa.us
Whole thread Raw
In response to postgresql 7.2b4 bug  ("guard" <guard29@seed.net.tw>)
List pgsql-hackers
"guard" <guard29@seed.net.tw> writes:
> timestamp(date '2000-12-25')
> error message>> parse error at or near "date"

This unfortunately is not a bug, but a deliberate change: TIMESTAMP is
now a reserved word, or at least more reserved than it used to be.
Use proper cast syntax (either CAST or :: style) to convert to timestamp.

> lpad('hi',4,'??')  >> not return '??hi'
> rpad('hi',4,'x')  >> return error string

These are bugs.  Fixed --- thanks for the report!
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Default permissions of system catalogs
Next
From: Tom Lane
Date:
Subject: Re: GETTIMEOFDAY_1ARG change