Re: difference between current_timestamp and now() in quotes

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: difference between current_timestamp and now() in quotes
Дата
Msg-id 497897DA.8000301@iol.ie
обсуждение исходный текст
Ответ на difference between current_timestamp and now() in quotes  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
On 22/01/2009 13:52, Grzegorz Jaśkiewicz wrote:

> test2=# insert into dupa(a) select 'current_timestamp' from
> generate_series(1,100);
> ERROR:  date/time value "current" is no longer supported

This doesn't answer your question, but you use current_timestamp without
the quotes, thus -

  insert into dupa(a) select current_timestamp ...

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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