BUG #4918: Weird input syntax for intervals

From: "Frank Spies" <frank(dot)spies(at)biotronik(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4918: Weird input syntax for intervals
Date: 2009-07-13 10:48:01
Message-ID: 200907131048.n6DAm1Gq033674@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: 4918
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
Details:

It feels totally weird that the two queries

1) select interval '13 month'
2) select interval '13' month

do not have the same result: result for 1) is "1 year 1 mon", result for 2
is "1 mon". Is this correct behaviour?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Chris Spotts 2009-07-13 13:09:49 Re: Re: [BUGS] BUG #4916: wish: more statistical functions (median, percentiles etc)
Previous Message Grzegorz Jaśkiewicz 2009-07-13 08:17:15 Re: Re: [BUGS] BUG #4916: wish: more statistical functions (median, percentiles etc)