Re: array containing references

Renaud Tthonnart wrote:

>
> 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