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

From Grzegorz Jaśkiewicz
Subject difference between current_timestamp and now() in quotes
Date
Msg-id 2f4958ff0901220552g6fbc9091t9307df5f17ad16fa@mail.gmail.com
Whole thread Raw
Responses Re: difference between current_timestamp and now() in quotes  (Raymond O'Donnell <rod@iol.ie>)
Re: difference between current_timestamp and now() in quotes  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: difference between current_timestamp and now() in quotes  (Dhaval Jaiswal <bablu_postgres@yahoo.com>)
List pgsql-general
test2=# create table dupa(a timestamp,  b serial);
NOTICE:  CREATE TABLE will create implicit sequence "dupa_b_seq" for
serial column "dupa.b"
CREATE TABLE

test2=# insert into dupa(a) select current_timestamp from
generate_series(1,100);
INSERT 0 100

test2=# insert into dupa(a) select 'current_timestamp' from
generate_series(1,100);
ERROR:  date/time value "current" is no longer supported
LINE 1: insert into dupa(a) select 'current_timestamp' from generate...
                                   ^
test2=# insert into dupa(a) select 'now()' from generate_series(1,100);
INSERT 0 100


Any ideas why the difference ?


--
GJ

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: [ADMIN] bytea size limit?
Next
From: Hannu Krosing
Date:
Subject: Re: [Plproxy-users] A complex plproxy query