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['str
Emi Lu 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
On 08/30/2011 11:24 AM, Tom Lane wrote:
Emi Lu writes:
Does psql provide something like the following query command?
select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')
If you remember the operator name equivalent to ILIKE (~~*)
you can do
select * from tablename
wh
Emi Lu writes:
> Does psql provide something like the following query command?
> select * from tablename
> where col1 not ilike ('str1%', 'str2%'... 'strN%')
If you remember the operator name equivalent to ILIKE (~~*)
you can do
select * from tablename
where not (col1 ~~* any(array['str1%', 'st
use a regex ?
On 08/30/2011 16:51, Emi Lu wrote:
Good morning,
Does psql provide something like the following query command?
select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')
Thanks a lot!
Emi
--
No trees were killed in the creation of this message.
However, many
Good morning,
Does psql provide something like the following query command?
select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')
Thanks a lot!
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
