Re: postgresql 7.2b4 bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "guard" <guard29(at)seed(dot)net(dot)tw>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql 7.2b4 bug
Date: 2002-01-08 17:05:52
Message-ID: 22609.1010509552@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"guard" <guard29(at)seed(dot)net(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-08 17:19:32 Re: GETTIMEOFDAY_1ARG change
Previous Message Thomas Lockhart 2002-01-08 17:00:03 Re: Time as keyword