From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mauricio Fernandez A. <mfacontacto@ono.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]'
Date: Wed, 11 Jan 2006 13:24:31 -0500
Message-ID: <20302.1137003871@sss.pgh.pa.us> (raw)
In-Reply-To: <KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com>
References: <KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com>
"Mauricio Fernandez A." <mfacontacto@ono.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, mfacontacto@ono.com
Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]'
In-Reply-To: <20302.1137003871@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox