Re: Array Values and References

From: Joe Conway <mail(at)joeconway(dot)com>
To: Omachonu Ogali <missnglnk(at)informationwave(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Array Values and References
Date: 2005-11-04 07:09:08
Message-ID: 436B0914.3010808@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-11-04 08:30:27 Re: Image File System Question
Previous Message Joe Conway 2005-11-04 06:59:00 Re: Looping through arrays