Re: difference between current_timestamp and now() in quotes - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: difference between current_timestamp and now() in quotes
Date
Msg-id 497897DA.8000301@iol.ie
Whole thread Raw
In response to difference between current_timestamp and now() in quotes  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List 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 by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: how to specify the locale that psql uses
Next
From: "Albe Laurenz"
Date:
Subject: Re: [ADMIN] bytea size limit?