Re: [sqlite] Ordered group by

2011-06-23 Thread J Decker
On Thu, Jun 23, 2011 at 8:37 AM, Jan Hudec wrote: > Hello All, > > Is there a way to do group by query with well defined order of calls to the > aggregate function? > > The problem is as follows. I have some objects in a database identified with > "obj_id". For each object, there are some arrays,

Re: [sqlite] Ordered group by

2011-06-23 Thread Jan Hudec
On Thu, Jun 23, 2011 at 12:48:51 -0400, Igor Tandetnik wrote: > On 6/23/2011 11:37 AM, Jan Hudec wrote: > > Is there a way to do group by query with well defined order of calls to the > > aggregate function? > > Not reliably. > > > So I want to denormalize the database by doing: > > > > crea

Re: [sqlite] Ordered group by

2011-06-23 Thread Igor Tandetnik
On 6/23/2011 11:37 AM, Jan Hudec wrote: > Is there a way to do group by query with well defined order of calls to the > aggregate function? Not reliably. > So I want to denormalize the database by doing: > > create temporary table packed_array ( > obj_id integer primary key, >

[sqlite] Ordered group by

2011-06-23 Thread Jan Hudec
Hello All, Is there a way to do group by query with well defined order of calls to the aggregate function? The problem is as follows. I have some objects in a database identified with "obj_id". For each object, there are some arrays, represented in the normalized form like: create table arra