Re: .3RC2 does not have datetime() function? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: .3RC2 does not have datetime() function?
Date
Msg-id 17810.1038413157@sss.pgh.pa.us
Whole thread Raw
In response to .3RC2 does not have datetime() function?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-bugs
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> Don't know if this is a bug or not but ... this query worked under 7.2.1
> but doesn't under 7.3RC2. datetime was a built-in function in 7.2.1 but
> seems to be "missing" from 7.3RC2 ...

> $ psql JC -c "select to_char(datetime(upload_time),'YYYY-MM-DD') as
> utime from products where id='989000627108' "
> ERROR:  Function datetime(timestamp without time zone) does not exist

You shouldn't have been using datetime() here anyway, AFAICS --- the
input was already a timestamp, so what was the point?

But yes, we deprecated that type name for two versions and it's now gone
completely.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Rod Taylor
Date:
Subject: Re: regression hickups w/ freebsd.
Next
From: Tom Lane
Date:
Subject: Re: createdb script bug in 7.3RC2?