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 years 6 mons
(1 row)
db_frank=# select version();
version
-------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4.0 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Ubuntu 4.3.3-5ubuntu4) 4.3.3, 64-bit
(1 row)
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 GmbH
Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRB 2918
Geschäftsführer: Dr. Max Schaldach, Christoph Böhmer, Dr. Werner Braun,
Dr. Lothar Krings
This email and the information it contains including attachments are
confidential and meant only for use by the intended recipient(s);
disclosure or copying is strictly prohibited. If you are not addressed,
but in the possession of this email, please notify the sender immediately
and delete the document.
