Thread: postgresql 7.2b4 bug

postgresql 7.2b4 bug

From
"guard"
Date:
dear sir
 
 
 
my database create -E UNICODE

can't run

timestamp(date '2000-12-25')
error message>> parse error at or near "date"

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

Re: postgresql 7.2b4 bug

From
Tom Lane
Date:
"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