"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.
From: Grzegorz Jaśkiewicz <gryzman@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
