Re: [GENERAL] beginner problems with count(*)

2010-04-08 Thread A. Kretschmer
In response to Me Self : > Hello Im just getting started using postgres and Ive run run into a > problem with count(*): > > When I do "select count(*) from mytable" or "select count(*) from > mytable where mycolumn=x" then I get wrong number. The number of rows > returned is lower than the actual

[GENERAL] beginner problems with count(*)

2010-04-08 Thread Me Self
Hello Im just getting started using postgres and Ive run run into a problem with count(*): When I do "select count(*) from mytable" or "select count(*) from mytable where mycolumn=x" then I get wrong number. The number of rows returned is lower than the actual number. How can that happen? The tabl