Horton

Re: Bug #605: timestamp(timestamp('a timestamp)) no longer works

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: andrew@catalyst.net.nz, pgsql-bugs@postgresql.org
Date: 2002-03-01T15:03:41Z
Lists: pgsql-bugs, pgsql-hackers 
pgsql-bugs@postgresql.org 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...

			regards, tom lane