"Michael Thorsen" <mthorsen1980@xxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
