Re: migracion III - El retorno de Charly Mendez
| From: | Ing. Roger Cobá | Date: | Fri, 17 Nov 2000 19:00:50 +0000 |
| Subject: | Re: migracion III - El retorno de Charly Mendez | ||
| References: | 1 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-3965@lists.php.net to get a copy of this message | ||
Prueba con esto:
SELECT site_temp.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
Espero sirva de algo.
----- Original Message -----
From: "Javier Leyba" <jleyba@sabueso.net>
To: "Lista PHPES" <lista@phpes.com>
Sent: Friday, November 17, 2000 11:40 AM
Subject: [PHP-ES] migracion III - El retorno de Charly Mendez
>
> 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
>
>
>
>
> ---------------------------------------------------------------------
> Archivo On-line: http://www.phpes.com/
> Manual PHP en español: http://www.php.net/manual/es/
> Para dar de baja la suscripción, mande un mensaje a:
> lista-unsubscribe@phpes.com