Re: Why is this allowed?

"Chuck McDevitt" <cmcdevitt@greenplum.com> 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 means.

You've requested an interval measured in days and supplied '1' as the value
which is read as a single second. 

Hm, the documentation doesn't describe this syntax but the comments in the
source imply that this postfix precision notation is required and there's
quite a bit of code in gram.y to support it.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com