On Mon, Aug 01, 2011 at 04:50:00PM -0600, Wes James wrote: > select count(*) from table; > > count > ------- > 100 > (1 row) > > > is correct > > select count(*) from table where col::text ~~* '%text%'; > > count > ------- > 1 > (1 row) > > is correct. > > But now if I do: > > > select count(*) from table where col::text !~~* '%text%'; > count > ------- > 98 > (1 row) > > Shouldn't it be 99? That is out of 100 records there is one that has > "text" in column "col" so the !~~* should return 99 rows. ??
Wild guess: select count (*) from table where col is null; count ------ 1 (1 row) ";-) Reinoud -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinou...@n.leeuwen.net http://reinoud.van.leeuwen.net kvk 27320762 __________________________________________________ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
