Re: Re: FWD: tinterval vs interval on pgsql-novice

Tom Lane writes:

> template1=# select ('today', interval '1 day') OVERLAPS ('yesterday', interval
> '18 hours');
> ERROR: parser: parse error at or near "overlaps"
>
> I don't understand why we're getting a parse error here ...

The OVERLAPS special SQL-construct is converted into the 'select
overlaps(...)' function call, which isn't allowed because OVERLAPS is a
keyword. *That* is where the parse error is coming from.

To fix this you simply need to double-quote "overlaps" when it's used as a
straight function call. See how substring does it in pg_proc.h.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/