"current_timestamp" is the reserved keyword of postgreSQL. When you executes it
within single quotation mark it treated as string & that is the only reason it
thrown error.
"Now()" is an in-built function you can use it with/without single quotation
mark.
For more information refere the below link.
http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html
--
Thanks & Regards
Dhaval Jaiswal
EnterpriseDB
www.enterprisedb.com
________________________________
From: Grzegorz Jaśkiewicz <gryz...@gmail.com>
To: GENERAL <pgsql-general@postgresql.org>
Sent: Thursday, January 22, 2009 7:22:21 PM
Subject: [GENERAL] difference between current_timestamp and now() in quotes
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
