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
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
I am trying to figure out how to use a regex and an ANY(), without any
luck, to determine if at least one element of an array (on the right)
matches the given constant pattern (on the left).
I think the problem is because the pattern expects to be on the right
side with the target on the left,
[EMAIL PROTECTED] writes:
I am trying to figure out how to use a regex and an ANY(), without any
luck, to determine if at least one element of an array (on the right)
matches the given constant pattern (on the left).
I think the problem is because the pattern expects to be on the right
side
On Tue, Jan 23, 2007 at 12:59:38AM -0500, Tom Lane wrote:
I think the problem is because the pattern expects to be on the right
side with the target on the left, but I want to do it reversed.
Yeah, the ANY syntax only allows the array on the right. You'd have to
make a LIKE-ish operator