.3RC2 does not have datetime() function?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема .3RC2 does not have datetime() function?
Дата
Msg-id 3DE49803.3080801@mega-bucks.co.jp
обсуждение исходный текст
Ответы Re: .3RC2 does not have datetime() function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Sorry if this has been brought up before. I tried searching the archives
at http://archives.postgresql.org/pgsql-bugs/ but it seems the search
function is broke.

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
         Unable to identify a function that satisfies the given argument
types
         You may need to add explicit typecasts

JC

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: A little bug in postgreSQL
Следующее
От: Jean-Christian Imbeault
Дата:
Сообщение: createdb script bug in 7.3RC2?