From: Jaime Casanova <systemguards@gmail.com>
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:14:14 -0500
Message-ID: <c2d9e70e0601111014m3303f48ar24de908fe47fa592@mail.gmail.com> (raw)
In-Reply-To: <KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com>
References: <KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com>
On 1/11/06, Mauricio Fernandez A. <mfacontacto@ono.com> wrote:
> Hello I have been working in a report based on the query bellow. It works
> fine in my development server which is postgres 8.0 but in production I have
> postgres 7.3 and I am getting the following error:
>
> SQL Error :
> ERROR: Unable to identify an ordering operator '<' for type 'smallint[]'
> Use an explicit ordering operator or modify the query
>
> In declaration:
> select ac.idanalisis, ac.idpt, pt.codigohospital, ct.nombre as
> nombrehospital,
> pt.codigomedico, m.nombre || ' ' || m.apellidos as nombremedico,
> ac.pacact,
> ac.potencialpacientes, ac.planvisitas
> from plannegocio.analisiscliente ac
> inner join plannegocio.planterritorio pt on ac.idpt = pt.idpt
> inner join centrotrabajo ct on pt.codigohospital = ct.codigo
> inner join medico m on pt.codigomedico = m.codigo
> where ac.idpt in
> (select pt.idpt from plannegocio.planterritorio pt where pt.idplan =
> 1)
> group by ac.idanalisis, ac.idpt, pt.codigohospital, ct.nombre,
> pt.codigomedico,
> nombremedico, ac.pacact, ac.potencialpacientes, ac.planvisitas
> order by ct.nombre, nombremedico
>
> 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.
>
> Can somebody help me?.
> thanks in advance
>
> Mauricio Fernández A.
> Ingeniero de Sistemas
> U. Autónoma de Manizales
>
>
that's why is a bad idea to develop in version that is superior to the
one you will use in production...
my advice, upgrade your production server to 8.1.2... there were some
work in arrays in 8.x.x
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
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: systemguards@gmail.com, mfacontacto@ono.com
Subject: Re: Unable to identify an ordering operator '<' for type 'smallint[]'
In-Reply-To: <c2d9e70e0601111014m3303f48ar24de908fe47fa592@mail.gmail.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