Re: why these results?
| От | Wes James |
|---|---|
| Тема | Re: why these results? |
| Дата | |
| Msg-id | CAFjCMHtkoAj5hDKw_c2X76tqZDiUthx=g=nSwpdPCLhnVm-Bww@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: why these results? (Steve Crawford <scrawford@pinpointresearch.com>) |
| Список | pgsql-sql |
Yes. Thanks to all that responded. That was it. -wes On Mon, Aug 1, 2011 at 5:01 PM, Steve Crawford <scrawford@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 >
В списке pgsql-sql по дате отправления: