> > 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.
> Hmm. Why was this required for the substring() example? afaik all of
> this should be handled (correctly) in the grammar...
I see it now. Will look
> 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.
Hmm. Why was this required for the substring() example? afaik all of
this should be handled (correctly) in the grammar...
- Thomas
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
o
> (the second one fails). Now that I look, this breakage was introduced in
> March when "we" expunged operators allowed as identifiers (Tom Lane and
> I have blood on our hands on this one ;) See gram.y around line 5409.
> Suggestions?
Any problems with allowing OVERLAPS and BETWEEN as function n
