On Fri, Oct 14, 2005 at 07:09:17PM -0400, Tom Lane wrote: > I wrote: > > I'm thinking that IN should be converted to a ScalarArrayOpExpr, > > ie > > > x = ANY (ARRAY[val1,val2,val3,val4,...]) > > Actually, there is one little thing in the way of doing this: it'll > fail if any of the IN-list elements are NULL, because we have not > got support for arrays with null elements. So we'd have to fix > that first.
+1 on fixing that. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
