Re: Foreign key to a view (UNION of two or more tables), any alternative? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Foreign key to a view (UNION of two or more tables), any alternative?
Date
Msg-id 20050620144000.GA25460@wolff.to
Whole thread Raw
In response to Re: Foreign key to a view (UNION of two or more tables), any alternative?  (Jose Gonzalez Gomez <jgonzalez.openinput@gmail.com>)
List pgsql-general
On Sun, Jun 19, 2005 at 17:16:34 +0100,
  Jose Gonzalez Gomez <jgonzalez.openinput@gmail.com> wrote:
> >
> There would be no problem in doing so with such an easy case, but
> think about having a table with cities (hundred, thousands?) and then
> have four copies for each of the above posibilities with its related
> maintenance nightmare.

You still have to maintain the data somehow. I think it would be
easier with more cities to have a table holding the results rather
than try to hard code something into the table definition.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Help! What has changed in the internal structure of
Next
From: Michael Fuhr
Date:
Subject: Re: External (asynchronous) notifications of database updates