Re: Set Operators and Arrays Question

> Wish List Solution:
>
> Heres what I think would be really the best way to solve the problem.
>
> create table member ( member_id serial, data text);
> create table mailing ( mailing_id serial, name text);
> create table memb_mailing ( member_id int,mailings int[]);
>
> Here the initial mailings array is empty and I say things like:
>
> update memb_mailing add 27 into mailings
> where member_id=templist.member_id;
>
> This just inserts the letter number 27 into the mailings array. And we could
> also say things like:
>
> select M.member_id from member M,memb_mailing MM
> where M.member_id=MM.member_id and
> MM.mailings contains 27;

You may want to look at the contrib/array directory for additional
functions and operators for arrays (which includes is this an element
of this array function/operator)