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
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?
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
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
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%';