"Josh Berkus" <josh@agliodbs.com> writes:
> Please help! I just upgraded a production database to PostgreSQL 7.2,
> and discovered that INTERVAL() is no longer a function. What replaced
> it? How can I convert VARCHAR to Interval?
It's still there, but INTERVAL is a reserved word these days.
"INTERVAL"(varcharvalue)
varcharvalue::interval
CAST(varcharvalue AS interval)
should all give the same results. Only the last of these is actually
standard.
regards, tom lane