Skip site navigation (1) Skip section navigation (2)

Re: BUG #4918: Weird input syntax for intervals

From: Frank Spies <frank(dot)spies(at)biotronik(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4918: Weird input syntax for intervals
Date: 2009-07-16 19:17:58
Message-ID: OFCBB72E0F.E738B164-ONC12575F5.00697187-C12575F5.006A03BA@biotronik.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

In response to

pgsql-bugs by date

Next:From: Frank van VugtDate: 2009-07-16 19:42:12
Subject: Re: bug or simply not enough stack space?
Previous:From: Juan C. AragonDate: 2009-07-16 18:50:52
Subject: FATAL: could not reattach to shared memory (key=268, addr=01E30000): 487

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group