Unable to identify an ordering operator '<' for type
'smallint[]'
"Mauricio Fernandez A." <[EMAIL PROTECTED]> writes:
> The only strange thing in the query is that ac.potencialpacientes is
> smallint[] (in fact is the only thing with sense I
"Mauricio Fernandez A." <[EMAIL PROTECTED]> 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.po
On 1/11/06, Mauricio Fernandez A. <[EMAIL PROTECTED]> 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: Una
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[]'
U
Ferruccio Zamuner <[EMAIL PROTECTED]> writes:
> select persons.name,firm.name,persons.tel
>from persons,work,firm
>where (persons.table_owner=0) and
> (work.id_firm=firm.id and work.id_person=persons.id)
> union
>select persons.name,firm.name,persons.t
Hello,
select persons.name,firm.name,persons.tel
from persons,work,firm
where (persons.table_owner=0) and
(work.id_firm=firm.id and work.id_person=persons.id)
union
select persons.name,firm.name,persons.tel
from persons,work,firm
wh
