Re: Group By Problem with PostgreSQL

Did you weere able to do a work around?

On Tuesday, September 6, 2011 4:10:56 PM UTC-3, gabrielr wrote:

Hi everybody.

I Have a problem making a GROUP BY operation with PostgreSQL Database.

This is my  Code
<code>
        $apoyosEstado = $this->EncApoyo->find('all',array(
 
'fields'=>array('MAX(Estado.estado_id) AS
edo_id','MAX(Estado.descripcion) AS
estado','COUNT(EncApoyo.enc_apoyo_id) AS total'),
                                                    'group'=>
array('Estado.estado_id')
                                            ));
</code>
And It return an ERROR because Cake Adds the primary key to the SQL
QUERY. some like this:

SELECT MAX("Estado"."estado_id") AS edo_id,
MAX("Estado"."descripcion") AS estado,
COUNT("EncApoyo"."enc_apoyo_id") AS total, "EncApoyo"."enc_apoyo_id"
AS "EncApoyo__enc_apoyo_id" FROM "enc_apoyos" AS "EncApoyo" LEFT JOIN
"estados" AS "Estado" ON ("EncApoyo"."estado_id" =
"Estado"."estado_id") WHERE 1 = 1 GROUP BY "Estado"."estado_id"

This is an error because in PostgreSQL fields to display in a GROUP BY
query must be contained in an aggregate function.

If someone knows who solve it, answer me please.

Thanks.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php