Postgres Pro
Downloads
Home   >   mailing lists

two foreign keys - Mailing list pgsql-novice

From Brian
Subject two foreign keys
Date
Msg-id 5.1.0.14.2.20020216131821.00adc9a0@mail.attbi.com
Whole thread Raw
Responses Re: two foreign keys
List pgsql-novice
Tree view 
I have a table that has two foreign keys to the same table.

- operator_id_start
- operator_id_stop

Both point to the operator table.

When displaying the row from the table how do I join so that I can have both Operator table details available?

-----

pgsql-novice by date:

Previous
From: "PG Explorer"
Date:
Subject: Re: Updated to 7.2 now can't createlang..
Next
From: "Josh Berkus"
Date:
Subject: Re: two foreign keys