Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id AE0A06336F5 for ; Tue, 18 Aug 2009 04:52:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 31757-08 for ; Tue, 18 Aug 2009 07:52:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f208.google.com (mail-bw0-f208.google.com [209.85.218.208]) by mail.postgresql.org (Postfix) with ESMTP id A07776328EB for ; Tue, 18 Aug 2009 04:52:46 -0300 (ADT) Received: by bwz4 with SMTP id 4so2887839bwz.24 for ; Tue, 18 Aug 2009 00:52:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:content-type :content-transfer-encoding; bh=iRBt0xYr1E+O56RHgvDGdGzo1L6Q4fZx4T5B/I/lx7w=; b=SCZSRtJtt3xPXe9DF6jT3stPrQgIZCeAOAzSW4Wdp22175XrpsIuRBGgkmjtAdEfHJ e7/lZcPShm/XeOyGRgGTOKbiiPwPspKND7nEYBuxnwuX5XZhT6VYd1QsdYKLuxVXgFvv UW8dMdDZwHa4KoKIC5Z2YEI/LG3+Mg7uMjMT8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; b=WE/kd4QWxiGCWJS/iNS+PclaCL0nsbeS3JN9NxAK5YymIMn/yfJCyyTXV3v+ORRdL6 MnauQ01moMAbTx0kCKV9Tn7uVWSrzCo42kcPgvJB8LsBGvsBOeH7UyfKUOv/NaqCOHOW Ggu5weWzOLmL1N4xlf+mAEC8gIBLQDFrhAsgE= Received: by 10.103.87.33 with SMTP id p33mr1741110mul.94.1250581646317; Tue, 18 Aug 2009 00:47:26 -0700 (PDT) Received: from ?192.168.0.100? ([95.108.20.1]) by mx.google.com with ESMTPS id b9sm22813170mug.39.2009.08.18.00.47.25 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 18 Aug 2009 00:47:25 -0700 (PDT) Message-ID: <4A8A5C8C.40809@gmail.com> Date: Tue, 18 Aug 2009 09:47:24 +0200 From: "W. Kinastowski" User-Agent: Thunderbird 2.0.0.22 (X11/20090605) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: operator contains in older Pgsql Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 200908/85 X-Sequence-Number: 32994 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.