Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)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
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-11-27 16:10:28|
|Subject: Re: createdb script bug in 7.3RC2? |
|Previous:||From: Rod Taylor||Date: 2002-11-27 13:23:10|
|Subject: Re: regression hickups w/ freebsd.|