[gnome-db] GdaSqlQuery: sub-queries

[Murray Cumming <murrayc murrayc com>]

In Glom I have a generic function like so:
int count_rows_returned_by(const std::string& sql_query)
{
  std::string query_count = 
    "SELECT COUNT (*) FROM (" 
    + sql_query 
    + ") AS glomarbitraryalias";
  ...
}

So with GdaSqlBuilder, is there any way to use a sub-query as the
target? gda_sql_builder_select_add_target_id() seems to be only for
specifying tables as targets:
http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-add-target-id
 
I tried passing the result of gda_sql_builder_compound_add_sub_select(),
but I think that's for something else. It resulted in a failed
G_VALUE_HOLDS_STRING() check.

-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com