On Tue, Jan 23, 2007 at 09:30:49AM -0500, Tom Lane wrote: > Martijn van Oosterhout <kleptog@xxxxxxxxx> 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@xxxxxxxxxx> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote!
