Just to be clear, the ISO SQL spec says that INTERVAL '1' DAY is the
correct way to specify a one-day interval.
That's why it is surprising that PostgreSQL treats it differently, with
no error or warning.
The PostgreSQL syntax INTERVAL '1 DAY' is non-standard.
Is fixing this on the TODO list?
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 10, 2007 5:11 PM
To: Gregory Stark
Cc: Chuck McDevitt; email@example.com
Subject: Re: [HACKERS] Why is this allowed?
Gregory Stark <[EMAIL PROTECTED]> writes:
> "Chuck McDevitt" <[EMAIL PROTECTED]> writes:
>> Why don't we have some kind of error check for people entering things
>> like INTERVAL '1' DAY in their query, since we don't handle it.
> Because it's not an error. It just doesn't mean what you think it
What it is is an incompletely implemented feature. That syntax is
required by the SQL spec, and Tom Lockhart had been making progress
towards supporting it when he got bored and left the project. Where
he left it is that the grammar accepts it but the interval input routine
isn't paying any attention to the qualifier.
I'm not eager to rip out what's there, but I don't personally feel
like making it work either...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?