Re: array containing references

Michael Ansley wrote:

>
>
> Use the array stuff in the contrib directory. There are functions
> there to do this.
>
> Cheers...
>
> MikeA
>
>
> > CREATE TABLE xxx
> > (
> > id int,
> > nom varchar(10),
> > ref int[],
> > PRIMARY KEY(id)
> > );
> >
> > INSERT INTO xxx VALUES( 1,'aaa','{10,20,30,50}');
> > INSERT INTO xxx VALUES( 2,'bbb','{10,30,40}');
> > INSERT INTO xxx VALUES( 3,'ccc','{20,40}');
> >
>
> Or more simply:
> How can I get ihe id of the tuple for which the array contains 30 for
> example
>
>

Thank you for your help but could you be more clear?
Where exactly do I search to find array stuff.
I went on the website of postgresql in directory contrib of download but
I didn't find it.

Cheers, Renaud THONNART