Igor Korot <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
