Re: Regular expressions and arrays and ANY() question - Mailing list pgsql-general

On Tue, Jan 23, 2007 at 09:30:49AM -0500, Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
> > If you created such a function, and made an operator with it that
> > was a communtator of LIKE (call it "is liked by"), would the
> > planner be smart enough to split the ANY and commutate it to the
> > normal order?
>
> No, at least not as of 8.2, because ANY translates as a
> ScalarArrayOpExpr which only comes in the one flavor (array on the
> right).

How hard would it be to add the array-on-the-left flavor?

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!