| 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: | Whole Thread | Raw Message | 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)
| 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 |