From: | "Mauricio Fernandez A(dot)" <mfacontacto(at)ono(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Unable to identify an ordering operator '<' for type 'smallint[]' |
Date: | 2006-01-11 17:55:01 |
Message-ID: | KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2006-01-11 18:14:14 | Re: Unable to identify an ordering operator '<' for type 'smallint[]' |
Previous Message | Mario Splivalo | 2006-01-10 14:18:47 | Regexp group matching - extracting second group element? |