Re: [gnome-db] SELECT DISTINCT with GdaSqlBuilder

[Vivien Malerba <vmalerba gmail com>]

On 28 February 2010 00:06, Murray Cumming <murrayc murrayc com> wrote:
> On Sat, 2010-02-27 at 14:45 +0100, Vivien Malerba wrote:
>> On 27 February 2010 12:37, Murray Cumming <murrayc murrayc com> wrote:
>> > How can I use the DISTINCT keyword when creating a SELECT statement with
>> > GdaSqlBuilder?
>> >
>>
>> You can't! It seems I forgot about that...
>> Here is the API I propose for that:
>>
>> void gda_sql_builder_select_set_distinct (GdaSqlBuilder *builder,
>> gboolean distinct, guint expr_id)
>> with the last field optionnal if @distinct is TRUE, and ignored if
>> @distinct is FALSE
>
> Thanks.
>
> What would expr_id represent? The rest of the SQL statement?

The @expr_id is the optionnal expression used when there is a
"DISTINCT ON <expr>" construct.

>
>> Also there is no API to set limits, so I propose:
>> void gda_sql_builder_select_set_limit (GdaSqlBuilder *builder, guint
>> limit_count_expr_id, guint limit_offest_expr_id)
>
> Again, thanks, though I don't know what the two IDs would be.

They represent the limit count and offset.

I'll implement these new methods ASAP.

regards,

Vivien