Hi,
I played a bit with the interval syntax and found this, this time on a 8.4=
=20
release:
psql -ddb_frank
psql (8.4.0)
Type "help" for help.
db_frank=3D# select interval '2.5' year;
interval
----------
2 years
(1 row)
db_frank=3D# select interval '2.5 year';
interval
----------------
2 years 6 mons
(1 row)
db_frank=3D# select version();
version
---------------------------------------------------------------------------=
----------------------------------
PostgreSQL 8.4.0 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real=20
(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=E4rin:
BIOTRONIK Mess- und Therapieger=E4te GmbH
Sitz der Gesellschaft: Berlin, Registergericht: Berlin HRB 2918
Gesch=E4ftsf=FChrer: Dr. Max Schaldach, Christoph B=F6hmer, Dr. Werner Brau=
n,=20
Dr. Lothar Krings
This email and the information it contains including attachments are=20
confidential and meant only for use by the intended recipient(s);=20
disclosure or copying is strictly prohibited. If you are not addressed,=20
but in the possession of this email, please notify the sender immediately=
=20
and delete the document.