"Frank Spies" <frank.sp...@biotronik.com> writes: > It feels totally weird that the two queries > 1) select interval '13 month' > 2) select interval '13' month > do not have the same result: result for 1) is "1 year 1 mon", result for 2 > is "1 mon". Is this correct behaviour?
$ psql psql (8.4.0) Type "help" for help. regression=# select interval '13 month'; interval -------------- 1 year 1 mon (1 row) regression=# select interval '13' month; interval -------------- 1 year 1 mon (1 row) You sure you are on 8.4.0? We were fooling with the interval input code quite late in 8.4 beta. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs