Re: Unable to identify an ordering operator '<' for type 'smallint[]'

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(at)sss(dot)pgh(dot)pa(dot)us]
Enviado el: miércoles, 11 enero, 2006 19:25
Para: Mauricio Fernandez A.
CC: pgsql-sql(at)postgresql(dot)org
Asunto: Re: [SQL] Unable to identify an ordering operator '<' for type
'smallint[]'

"Mauricio Fernandez A." <mfacontacto(at)ono(dot)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