Re: BUG #4918: Weird input syntax for intervals

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.