order of adding date & interval values?

Поиск
Список
Период
Сортировка
От Lev Lvovsky
Тема order of adding date & interval values?
Дата
Msg-id Pine.BSF.4.21.0205021714390.87204-100000@renegade.pfksound.com
обсуждение исходный текст
Ответы Re: order of adding date & interval values?
Re: order of adding date & interval values?
Список pgsql-general
hello,

using 7.2.1

is there any reason why the order of operations of the following query
would matter?

here's an example:

diw=# select interval '40 years' +  date '2001-01-01' as test;
        test
---------------------
 2001-01-01 00:00:00
(1 row)

diw=# select date '2001-01-01' + interval '40 years' as test;
        test
---------------------
 2041-01-01 00:00:00
(1 row)

note how the first query doesn't return the proper response.


also, is there a difference between:
"interval('40 years') " and "interval '40 years' " ?

or

"date('2001-01-01')" and "date '2001-01-01' " ?

because only the query at the top of this message works, the following
doesn't:

diw=# select date('2001-01-01') + interval('40 years') as test;
ERROR:  parser: parse error at or near "'"

I realize that answers my question, but why?

any help would be appreciated!!!


В списке pgsql-general по дате отправления:

Предыдущее
От: Anna Dorofiyenko
Дата:
Сообщение: select from function
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: hexadecimal values