I am surprised by this behavior of group_concat(): sqlite> select group_concat(name, ' ') AS 'names' from moca_config order by name; names bonding cof lof_update moca_core_trace_enable preferred_nc rf_band verbose sqlite> select group_concat(name, ' ') AS 'names' from moca_config where enable == 1 order by name; names rf_band verbose moca_core_trace_enable preferred_nc lof_update bonding
Notice that adding a 'where' clause has caused the order to be reversed from what was requested in the query. Why is this and what can I do to correct it?
Thanks, Bob -- Bob Friesenhahn [email protected], http://www.simplesystems.org/users/bfriesen/ GraphicsMagick Maintainer, http://www.GraphicsMagick.org/ _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
