Re: Reference to multiple cols - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Reference to multiple cols
Date
Msg-id 20030112165318.GA31080@wolff.to
Whole thread Raw
In response to Re: Reference to multiple cols  ("Ville Jungman" <ville_jungman@hotmail.com>)
List pgsql-novice
On Sun, Jan 12, 2003 at 15:06:03 +0200,
  Ville Jungman <ville_jungman@hotmail.com> wrote:
> Thank You for help!
>
> Still i have one problem left. How can i determine which table's row
> references to the main table row if i don't want to read every referencing
> table and search the right row. That was a part of the original problem and
> idea why i first wanted that the main table had the column that references
> to other tables.

If you use the suggestion to also have an animal type column in each table,
then you can check the animal type to see which auxillary table to
look at.

pgsql-novice by date:

Previous
From: "Ville Jungman"
Date:
Subject: Re: Reference to multiple cols
Next
From: Lex Berezhny
Date:
Subject: Re: Reference to multiple cols