Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9A11A9FA4DF for ; Tue, 30 Jan 2007 06:45:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 17263-07 for ; Tue, 30 Jan 2007 06:45:02 -0400 (AST) X-Greylist: delayed 00:05:24.009948 by SQLgrey-1.7.4 Received: from pulsesoft.com (mail.pulsesoft.com [217.73.1.144]) by postgresql.org (Postfix) with ESMTP id 8123C9F9428 for ; Tue, 30 Jan 2007 06:45:05 -0400 (AST) Received: from [192.168.100.104] ([212.112.174.211]) by pulsesoft.com (pulsesoft.com [217.73.1.144]) (MDaemon PRO v9.0.4) with ESMTP id md50000381601.msg for ; Tue, 30 Jan 2007 11:33:26 +0100 Message-ID: <45BF20A7.6050206@panagora.se> Date: Tue, 30 Jan 2007 11:40:39 +0100 From: Niklas Bergius Organization: Panagora Room AB User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Arrays, multidimensional ANY (v 8.2) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Processed: pulsesoft.com, Tue, 30 Jan 2007 11:33:26 +0100 (not processed: message from valid local sender) X-MDRemoteIP: 212.112.174.211 X-Return-Path: niklas@panagora.se X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: pulsesoft.com, Tue, 30 Jan 2007 11:33:27 +0100 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50 X-Spam-Level: X-Archive-Number: 200701/154 X-Sequence-Number: 27306 Hello everyone. Can anyone tell me how I can test for the occurrence of an array in an array? Intuitively, this should work: SELECT ARRAY[1,2,3] = ANY(ARRAY[[1,2,3],[2,3,4]]); However, this gives me "operator does not exist: integer[] = integer". I'm running 8.2. -- Niklas Bergius