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

 







dear sir
 
 
 
my database create -E UNICODEcan't runtimestamp(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
Sun, 6 Jan 2002 10:32:43 +0800
"guard" <guard29@seed.net.tw>
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

Tue, 08 Jan 2002 12:05:52 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: postgresql 7.2b4 bug 