Re: [GENERAL] Why am I getting doubles? - Mailing list pgsql-general

Igor Korot <ikorot01@gmail.com> writes:
> Is there a reason I'm seeing duplicate records on the query above?

Your example isn't complete, but I think the problem is your
WHERE clause isn't equating enough columns.  For instance,
if I do

db=# create table pp(f1 int, f2 int, primary key (f1,f2));
CREATE TABLE

that produces two rows in information_schema.key_column_usage:

 db                 | public            | pp_pkey         | db            | public       | pp         | f1          |
            1 |                               
 db                 | public            | pp_pkey         | db            | public       | pp         | f2          |
            2 |                         

Your WHERE clause can't tell the difference between these.

            regards, tom lane