Re: difference between current_timestamp and now() in quotes

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: difference between current_timestamp and now() in quotes
Date: 2009-01-22 15:59:22
Message-ID: 497897DA.8000301@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-01-22 16:08:32 Re: [GENERAL] bytea size limit?
Previous Message Informatica-Cooperativa Cnel. Oviedo 2009-01-22 15:55:26 Sugerencia de opcion