Yes. Thanks to all that responded. That was it. -wes
On Mon, Aug 1, 2011 at 5:01 PM, Steve Crawford <scrawf...@pinpointresearch.com> wrote: > On 08/01/2011 03:50 PM, 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. ?? >> >> -wes >> > select count(*) from table where col is null; > > (null is neither equal nor not-equal to anything, even null) > > Cheers, > Steve > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
