On 22 Jan 2017, at 2:40am, Keith Medcalf <kmedc...@dessus.com> wrote:
> My suggestion would be to forgo the artificial relative position being > computed by the application and replace it with the actual data used to > determine the ordering, and add an appropriate ORDER BY when retrieving the > data. Or make the field REAL instead of INTEGER. Then you can insert a new row 'between' any two existing rows by taking the mean of their two values. Well, down to the resolution of REAL, of course. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
