X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2FF2E9DC869 for ; Wed, 11 Jan 2006 14:24:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36313-03 for ; Wed, 11 Jan 2006 14:24:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 679839DC874 for ; Wed, 11 Jan 2006 14:24:38 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0BIOVkZ020303; Wed, 11 Jan 2006 13:24:31 -0500 (EST) To: "Mauricio Fernandez A." cc: pgsql-sql@postgresql.org Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]' In-reply-to: References: Comments: In-reply-to "Mauricio Fernandez A." message dated "Wed, 11 Jan 2006 18:55:01 +0100" Date: Wed, 11 Jan 2006 13:24:31 -0500 Message-ID: <20302.1137003871@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.083 required=5 tests=[AWL=0.083] X-Spam-Score: 0.083 X-Spam-Level: X-Archive-Number: 200601/43 X-Sequence-Number: 23832 "Mauricio Fernandez A." writes: > The only strange thing in the query is that ac.potencialpacientes is > smallint[] (in fact is the only thing with sense I can see in the error > message) but I am not using the '<' operator as it suggest. No, but you're trying to GROUP BY ac.potencialpacientes, and in 7.3 the only way to do grouping is sort/unique. So you have to be able to sort the datatype, and 7.3 doesn't have code to do comparison of arrays. > Can somebody help me?. Upgrade. 7.3 is pretty ancient anyway. Quite aside from lack of features, its performance is poor compared to 8.1. regards, tom lane