Hi Tom,
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?
First, where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%'])) will
work for me.
But I feel " ilike ('str1', ... 'strN')" is more intuitive, isn't it?
I have a feeling that windows functions deal with all fancy functions. I
would consider ilike ('str'...) as a non-standard SQL command?
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
