DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	b=jSFKqYEHMMLv0TknT7UDpaHtS10In9s+2b7cp/s9RcekSl/jjCwmkLilDZefMqQze2
	jyqbg48M+45dBwLBiH394RZL/xAxBGid+8dTOBKRurGiUmwBzbSBCfgee6kL4po/r/HO
	T8Er4ilmsD7YwIZ6XVicuIr6a7BI4F95QgaJ0=
Message-ID: <4A8A7F9A.3070906@gmail.com>
Date: Tue, 18 Aug 2009 12:16:58 +0200
From: "W. Kinastowski" <kinastowski@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (X11/20090605)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: operator contains in older Pgsql
References: <4A8A5C8C.40809@gmail.com> <h6dt5n$t9a$3@reversiblemaps.ath.cx>
In-Reply-To: <h6dt5n$t9a$3@reversiblemaps.ath.cx>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit

Jasen Betts wrote:
> On 2009-08-18, W. Kinastowski <kinastowski@gmail.com> wrote:
>   
>> I need a functionality of "@>" array operator in 8.1 Pg server. i.ex.
>> SELECT * FROM table WHERE array_col @> ARRAY ['xxx']  (works in 8.2, 
>> error in 8.1)
>> How to performe such a query ?  Is it possible ? Thanks for help.
>>     
>
>  SELECT * FROM table WHERE 'xxx' = ANY( array_col )
>
>
>   
thanks, it works ... and when there is more elements in array: i.ex
SELECT * FROM table WHERE array_col @> ARRAY ['xxx', 'yyy']
i need to
SELECT * FROM table WHERE 'xxx' = ANY( array_col ) AND 'yyy' = ANY( 
array_col )
is that correct ?