Re: Array Values and References - Mailing list pgsql-general

From Joe Conway
Subject Re: Array Values and References
Date
Msg-id 436B0914.3010808@joeconway.com
Whole thread Raw
In response to Array Values and References  (Omachonu Ogali <missnglnk@informationwave.net>)
List pgsql-general
Omachonu Ogali wrote:
> I have a table that contains my unique identifiers and their
> respective values. In another table, I have a field that is an
> array of integers.
>
> Is there a simple way for one to build a constraint that checks
> each array value against the primary key table even though the
> field types don't exactly match? (i.e. int vs int[])

A trigger perhaps?

Joe


pgsql-general by date:

Previous
From: MaXX
Date:
Subject: Re: Changing ids conflicting with serial values?
Next
From: Michael Fuhr
Date:
Subject: Re: Looping through arrays