Emi Lu <em...@encs.concordia.ca> writes: > On 08/30/2011 11:24 AM, Tom Lane wrote: >> select * from tablename >> where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%']));
> If next version could have "not ilike ('', '')" added into window > functions, that's will be great! Why? And what's this got to do with window functions? regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql