migracion III - El retorno de Charly Mendez
| From: | Javier Leyba | Date: | Fri, 17 Nov 2000 17:40:02 +0000 |
| Subject: | migracion III - El retorno de Charly Mendez | ||
| Groups: | php.general.es | ||
| Request: | Send a blank email to general-es+get-3957@lists.php.net to get a copy of this message | ||
Un nuevo problema para David Vincent:
Tiro en mi aplicacion PHP este query que en MySQL funcionaba joya, chiche-bombom y el benemerito
PostgrSQL me dice:
Database error: Invalid SQL: SELECT site.id AS id, uri, title, descr, country_id, SUM(score) AS
scoresum, cid FROM site, site_temp WHERE site.id = site_temp.id AND session =
'91b3fd0e2dea5a822a58e4c5463efa0f' GROUP BY site_temp.id ORDER BY scoresum DESC limit 15
PostgreSQL Error: 1 (ERROR: Attribute site.id must be GROUPed or used in an aggregate function )
Yo NO quiero agrupar por site.id.....que hago ???
Gracias
Javier