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:[EMAIL PROTECTED]
Enviado el: miércoles, 11 enero, 2006 19:25
Para: Mauricio Fernandez A.
CC: pgsql-sql@postgresql.org
Asunto: Re: [SQL]
"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
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
