From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: .3RC2 does not have datetime() function? |
Date: | 2002-11-27 16:05:57 |
Message-ID: | 17810.1038413157@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
completely.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-27 16:10:28 | Re: createdb script bug in 7.3RC2? |
Previous Message | Rod Taylor | 2002-11-27 13:23:10 | Re: regression hickups w/ freebsd. |