Re: [SQL] why these results?

2011-08-02 Thread Wes James
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

[SQL] why these results?

2011-08-01 Thread Wes James
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?

Re: [SQL] why these results?

2011-08-01 Thread Adrian Klaver
On Monday, August 01, 2011 3:50:00 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

Re: [SQL] why these results?

2011-08-01 Thread Reinoud van Leeuwen
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

Re: [SQL] why these results?

2011-08-01 Thread Steve Crawford
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%';