On Sat, 2002-03-02 at 04:16, Thomas Lockhart wrote:
> > timestamp(timestamp('a timestamp)) no longer works
> > I do this reasonably often in my code by way of being paranoid
> > that I might have a date, or a time, where I for sure _really_
> > want it to be a timestamp...
> > pcnz=# select timest
> timestamp(timestamp('a timestamp)) no longer works
> I do this reasonably often in my code by way of being paranoid
> that I might have a date, or a time, where I for sure _really_
> want it to be a timestamp...
> pcnz=# select timestamp('2002-03-01'::timestamp);
> ERROR: parser: parse error at
[EMAIL PROTECTED] writes:
> timestamp(timestamp('a timestamp)) no longer works
timestamp(x) is a type name now. In place of timestamp(foo) use
"timestamp"(foo)
foo::timestamp
CAST(foo AS timestamp)
And yes, this is pointed out in the migration notes...
Andrew McMillan ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
timestamp(timestamp('a timestamp)) no longer works
Long Description
In version 7.2 it seems that I can't reduntantly cast value to timestamp if it is
already a t
