| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, webb(dot)sprague(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Regular expressions and arrays and ANY() question |
| Date: | 2007-01-23 15:56:54 |
| Message-ID: | 20070123155654.GH5470@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jan 23, 2007 at 09:30:49AM -0500, Tom Lane wrote:
> Martijn van Oosterhout <kleptog(at)svana(dot)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(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-23 16:06:21 | Re: too many trigger records found for relation "item" - |
| Previous Message | Csaba Nagy | 2007-01-23 15:51:39 | Re: too many trigger records found for relation "item" - |