Unable to identify an ordering operator '<' for type 'smallint[]'
От | Mauricio Fernandez A. |
---|---|
Тема | Unable to identify an ordering operator '<' for type 'smallint[]' |
Дата | |
Msg-id | KPEAKEDEHEPGJLOLEDMBCEOOCFAA.mfacontacto@ono.com обсуждение исходный текст |
Ответы |
Re: Unable to identify an ordering operator '<' for type 'smallint[]'
Re: Unable to identify an ordering operator '<' for type 'smallint[]' |
Список | 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 modifythe 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 joincentrotrabajo 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
В списке pgsql-sql по дате отправления: