Re: difference between current_timestamp and now() in quotes
| От | Dhaval Jaiswal |
|---|---|
| Тема | Re: difference between current_timestamp and now() in quotes |
| Дата | |
| Msg-id | 996803.6917.qm@web111204.mail.gq1.yahoo.com обсуждение исходный текст |
| Ответ на | difference between current_timestamp and now() in quotes (Grzegorz Jaśkiewicz <gryzman@gmail.com>) |
| Список | pgsql-general |
"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.
--
Thanks & Regards
Dhaval Jaiswal
EnterpriseDB
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
В списке pgsql-general по дате отправления: