Обсуждение: what's wrong with this query

Поиск
Список
Период
Сортировка

what's wrong with this query

От
"Thomas T. Thai"
Дата:
still trying to port this app from mysql to pgsql, but getting this error:

Database error: Invalid SQL: select
t_stories.heading,t_stories.rid,count(*) as cmts from t_stories,t_comments
where t_comments.toprid = t_stories.rid and t_stories.verified = 'y' group
by t_comments.toprid order by t_stories.hits desc limit 5
PostgreSQL Error: 1 (ERROR: Attribute t_stories.heading must be GROUPed or
used in an aggregate function )
Session halted.

what's wrong with that query?

Re: what's wrong with this query

От
Alex Pilosov
Дата:
On Sun, 11 Feb 2001, Thomas T. Thai wrote:

> still trying to port this app from mysql to pgsql, but getting this error:
>
> Database error: Invalid SQL: select
> t_stories.heading,t_stories.rid,count(*) as cmts from t_stories,t_comments
> where t_comments.toprid = t_stories.rid and t_stories.verified = 'y' group
> by t_comments.toprid order by t_stories.hits desc limit 5
> PostgreSQL Error: 1 (ERROR: Attribute t_stories.heading must be GROUPed or
> used in an aggregate function )
> Session halted.
Precisely this:
---
PostgreSQL Error: 1 (ERROR: Attribute t_stories.heading must be GROUPed
or used in an aggregate function )
---
add t_stories.heading to group by list, and it should work. Mysql
apparently allows such sloppy sql, but postgres won't.