Re: What is the proper query

Or this is the bug in 9.1?
Since it looks like there are 2 columns with the same info in 1 table/view....

Thank you.

On Tue, Aug 22, 2017 at 12:08 AM, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> Hi, ALL,
> draft=# SELECT * FROM information_schema.key_column_usage WHERE
> table_schema = 'public' AND table_name = 'leaguescorehitter';
> constraint_catalog | constraint_schema | constraint_name
> | table_catalog | table_schema | table_name | column_name |
> ordinal_position | position_in_unique_constraint
> --------------------+-------------------+--------------------------------+---------------+--------------+-------------------+-------------+------------------+-------------------------------
> draft | public | leaguescorehitter_id_fkey
> | draft | public | leaguescorehitter | id |
> 1 | 1
> draft | public | leaguescorehitter_id_fkey1
> | draft | public | leaguescorehitter | id |
> 1 | 1
> draft | public | leaguescorehitter_id_fkey1
> | draft | public | leaguescorehitter | playerid |
> 2 | 2
> draft | public |
> leaguescorehitter_scoreid_fkey | draft | public |
> leaguescorehitter | scoreid | 1 |
> 1
> (4 rows)
>
> There are 3 foreign keys in that table.
>
> Is there a way to get values of 0, 1, 1, and 2 for the ordinal position?
>
> Thank you.