difference between current_timestamp and now() in quotes
| От | Grzegorz Jaśkiewicz |
|---|---|
| Тема | difference between current_timestamp and now() in quotes |
| Дата | |
| Msg-id | 2f4958ff0901220552g6fbc9091t9307df5f17ad16fa@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: difference between current_timestamp and now() in quotes
Re: difference between current_timestamp and now() in quotes Re: difference between current_timestamp and now() in quotes |
| Список | 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 по дате отправления: