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 <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly