[dev] PgSQL problems in scry

Dan Wilson dan at acucore.com
Thu Feb 13 11:31:10 PST 2003


PostgreSQL didn't like not having choice_value in the GROUP BY clause:

[dan at kamino dev_horde]$ cvs diff scry/lib/Driver/sql.php 
Index: scry/lib/Driver/sql.php
===================================================================
RCS file: /repository/scry/lib/Driver/sql.php,v
retrieving revision 1.17
diff -r1.17 sql.php
235c235
<                         ' GROUP BY scry_choices.poll_id, 
scry_choices.choice_id';
---
>                         ' GROUP BY scry_choices.poll_id, 
scry_choices.choice_value, scry_choices.choice_id';

-Dan




More information about the dev mailing list