Re: array containing references - Mailing list pgsql-general

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