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 по дате отправления: