On 3 May 2013, at 2:22am, James K. Lowden <jklow...@schemamania.org> wrote:
> I considered writing such a function, too. I didn't because relations > have no order. > > One might be tempted to say that's solved by ORDER BY. But > > 1. It's not clear that the rows are presented to the UDF in ORDER BY > order. There's no reason they should be, and a few they shouldn't, > including > > 2. Subqueries can't have ORDER BY, making the UDF non-deterministic by > definition. Also, ORDER BY can be on a non-unique field. So even with an ORDER BY you can sometimes get two different orders. Theoretically. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users