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 по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: how to specify the locale that psql uses
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: [ADMIN] bytea size limit?