From: Mauricio Fernandez A. <mfacontacto@ono.com>
To: pgsql-sql@postgresql.org
Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]'
Date: Wed, 11 Jan 2006 21:07:40 +0100
Message-ID: <KPEAKEDEHEPGJLOLEDMBOEPCCFAA.mfacontacto@ono.com> (raw)
In-Reply-To: <20302.1137003871@sss.pgh.pa.us>
Thanks Jaime, I know, you are right : it´s a very bad idea to develop in
version that is superior to the
one in production, but, mmmm.... I don`t know, you win ;).
And thanks to Tom too, because he told the key phrase "GROUP BY
ac.potencialpacientes", as I can skip that clause, now I get the result
expected
Thanks for your help
Mauricio Fernández A.
Ingeniero de Sistemas
U. Autónoma de Manizales
-----Mensaje original-----
De: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Enviado el: miércoles, 11 enero, 2006 19:25
Para: Mauricio Fernandez A.
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL] Unable to identify an ordering operator '<' for type
'smallint[]'
"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: mfacontacto@ono.com
Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]'
In-Reply-To: <KPEAKEDEHEPGJLOLEDMBOEPCCFAA.mfacontacto@ono.com>
* 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