> On Sep 14, 2017, at 1:23 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > You merely need to ONCE it either for each input row or for each result row. > So for example: > > select slow(a.x), slow(a.x)*slow(b.y), slow(b.y) from a, b where a.this == > b.that > > when computing the result set you merely compute ONCE slow(a.x) and ONCE > slow(b,y)
Interesting … I assume ONCE is something internal to the SQLite query engine? I don't see any reference to it in the SQL syntax or the other docs. Is there any way to achieve this effect without modifying SQLite? —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users