"Frank Spies" <frank(dot)spies(at)biotronik(dot)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