Hi,
I played a bit with the interval syntax and found this, this time on a 8.4
release:
psql -ddb_frank
psql (8.4.0)
Type "help" for help.
db_frank=# select interval '2.5' year;
interval
--
2 years
(1 row)
db_frank=# select interval '2.5 year';
interval
2 year
Hi Tom,
you are right, it's an RC I was running on.
Sorry...
Frank
www.biotronik.com
BIOTRONIK GmbH & Co. KG
Woermannkehre 1, 12359 Berlin, Germany
Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRA 6501
Vertreten durch ihre Komplementärin:
BIOTRONIK Mess- und Therapiegeräte Gm
"Frank Spies" 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.
regr
The following bug has been logged online:
Bug reference: 4918
Logged by: Frank Spies
Email address: frank.sp...@biotronik.com
PostgreSQL version: 8.4
Operating system: Linux
Description:Weird input syntax for intervals
Details:
It feels totally weird that the two qu
