Re: arrays and references

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: arrays and references
Date: 2002-03-21 13:25:02
Message-ID: a7cmve$1kbc$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mathieu Arnold wrote:

> Hi
>
> I was wondering if there was a possibity to do something like this :
> create table a (a int primary key);
> create table b (b int primary key, a int[] references a(a));
> to avoid having to create another table to join the two tables.
>

You could create table a, table containing b and a, and a view c, which
refers to a and b, giving you the structure you want.

--
Travis Bauer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nigel J. Andrews 2002-03-21 14:10:08 Re: Postmaster processes running out of control?
Previous Message Mathieu Arnold 2002-03-21 13:12:53 arrays and references