"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

Reply via email to