Estrange error

From: mtarcinalli(at)ig(dot)com(dot)br
To: pgsql-novice(at)postgresql(dot)org
Subject: Estrange error
Date: 2000-06-12 15:18:33
Message-ID: 200006121518.e5CFIXT45875@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I'm having the following error:
SELECT codigo, estado FROM entrega WHERE servico='1' GROUP BY estado ORDER
BY estado

Warning: PostgresSQL query failed: ERROR: Illegal use of aggregates or non-
group column in target list in /home/httpd/html/websites/wrodonto.com.
br/html/carrinho.php3 on line 487

The srange thing is that this error only occur in one of the servers.

Mateus T Machado
E-mail: mtarcinalli(at)ig(dot)com(dot)br
ICQ: 40075236

_________________________________________________________
Oi! Voc quer um iG-mail gratuito?
Ento clique aqui: http://www.ig.com.br/paginas/assineigmail.html

Browse pgsql-novice by date

  From Date Subject
Next Message luc00 2000-06-13 07:48:35 SELF Installing NT pgsql ?
Previous Message alias 2000-06-12 13:42:59