postgresql 7.2b4 bug

Started by guardabout 24 years ago2 messages
#1guard
guard29@seed.net.tw

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: guard (#1)
Re: postgresql 7.2b4 bug

"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