| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Ville Jungman <ville_jungman(at)hotmail(dot)com> |
| Cc: | josh(at)agliodbs(dot)com, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Reference to multiple cols |
| Date: | 2003-01-12 16:53:18 |
| Message-ID: | 20030112165318.GA31080@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Sun, Jan 12, 2003 at 15:06:03 +0200,
Ville Jungman <ville_jungman(at)hotmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lex Berezhny | 2003-01-12 17:14:51 | Re: Reference to multiple cols |
| Previous Message | Ville Jungman | 2003-01-12 13:06:03 | Re: Reference to multiple cols |