"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