| From: | Lev Lvovsky <lists1(at)sonous(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | order of adding date & interval values? |
| Date: | 2002-05-03 00:26:12 |
| Message-ID: | Pine.BSF.4.21.0205021714390.87204-100000@renegade.pfksound.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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!!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2002-05-03 00:29:21 | Re: hexadecimal values |
| Previous Message | Anna Dorofiyenko | 2002-05-02 23:55:39 | select from function |