how can i sort results in the array order then?
On May 13, 2:42 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > I think this is a SQL feature they sort list to use binary search in > the index for the table for efficiency). > > On May 13, 6:57 am, Francisco Costa <m...@franciscocosta.com> wrote: > > > is this a SQL Bug/feature? how can I change it? > > > On May 13, 11:53 am, Francisco Costa <m...@franciscocosta.com> wrote: > > > > I have this query db(db.space.id.belongs(result_id)).select() > > > the result id is an unsorted array of ids > > > I don't want the query results to be order by id > > > > The SQL list this > > > SELECT space.id, space.name FROM space WHERE space.id IN > > > (1,6,136,2,18,119,122) > > > > i want the result to be in the order of the ids array
