Postgres Pro
Downloads
Home   >   mailing lists

BUG #4918: Weird input syntax for intervals - Mailing list pgsql-bugs

From Frank Spies
Subject BUG #4918: Weird input syntax for intervals
Date
Msg-id 200907131048.n6DAm1Gq033674@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4918: Weird input syntax for intervals
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4918
Logged by:          Frank Spies
Email address:      frank.spies@biotronik.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?

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4890: Allow insert character has no equivalent in "LATIN2"
Next
From: Tom Lane
Date:
Subject: Re: BUG #4918: Weird input syntax for intervals