BUG #4935: Weird input syntax for intervals, part 2

From: "Frank Spies" <frank(dot)spies(at)biotronik(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4935: Weird input syntax for intervals, part 2
Date: 2009-07-23 12:56:36
Message-ID: 200907231256.n6NCua0V069386@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4935
Logged by: Frank Spies
Email address: frank(dot)spies(at)biotronik(dot)com
PostgreSQL version: 8.4
Operating system: Linux
Description: Weird input syntax for intervals, part 2
Details:

After finding out that bug #4918 was already fixed in 8.4 release, I played
around with the interval input syntax in 8.4 and found that
'2.5' year
is not the same as
'2.5 year'
in release 8.4:

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();
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

(I posted this already as reply to bug 4918, but nobody answered, probably
because the problem was already resolved)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-07-23 15:21:54 Re: BUG #4935: Weird input syntax for intervals, part 2
Previous Message Lauris Ulmanis 2009-07-23 10:47:47 Postgres user authentification or LDAP authentification