"Michael Thorsen" <[EMAIL PROTECTED]> writes:
> ... I gave a simple example above, but the query runs over 2 tables
> with about a million entries in each. So I am unable to verify what is
> wrong, but I know the count is incorrect as I should not have more than what
> is in the user_table.
You could easily get a count larger than the number of rows in
user_table, if there are rows in user_table that join to multiple rows
in the locations table. So look for duplicated data in locations ...
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
