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  (Raymond O'Donnell <rod@iol.ie>)
Re: difference between current_timestamp and now() in quotes  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: difference between current_timestamp and now() in quotes  (Dhaval Jaiswal <bablu_postgres@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: [ADMIN] bytea size limit?
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: [Plproxy-users] A complex plproxy query