On Sat, 30 Oct 2010 23:49:29 +0200
Viktor Bojović wrote:
>
> many tries have failed because 8GB of ram and 10gb of swap were not enough.
> also sometimes i get that more than 2^32 operations were performed, and
> functions stopped to work.
>
we have a similar problem and we use the Amara xml To
t;
>
> Amyyon
> Bijsterhuizen 11.58
> 6546 AS Nijmegen
> 050 - 311 5686
> www.amyyon.nl
> -Oorspronkelijk bericht-
> Van: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Namens Lutz Steinborn
> Verzonden: vrijdag 28 november 2008 14:52
> Aan: pgsql-sql@postgr
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock';
gives me 857
Why I'm not getting 955 for the last qu