Re: [gnome-db] SELECT DISTINCT with GdaSqlBuilder

[Vivien Malerba <vmalerba gmail com>]

On 30 March 2010 15:54, Murray Cumming <murrayc murrayc com> wrote:
> On Tue, 2010-03-30 at 15:46 +0100, Vivien Malerba wrote:
>> > However, next I need a way to add GROUP BY parts to the SQL
>> statement.
>> > Is there anything for that already?
>>
>> No, I'll have to add it:
>> To set the HAVING condition:
>> void gda_sql_builder_select_set_having (GdaSqlBuilder *builder, guint
>> cond_id);
>>
>> To add a GROUP BY expression:
>> void gda_sql_builder_select_group_by (GdaSqlBuilder *builder, guint
>> expr_id);
>>
>> And maybe, to remove a GROUP BY expression:
>> void gda_sql_builder_select_ungroup_by (GdaSqlBuilder *builder, guint
>> expr_id);
>
> Thank you, again.
>

This is now in git/master (except for
gda_sql_builder_select_ungroup_by() because it's more complicated to
implement
and because I'm not use it would be of any use).

Vivien