On 04/03/2013 2:20 PM, Petite Abeille wrote:
On Mar 4, 2013, at 1:32 AM, James K. Lowden <jklow...@schemamania.org> wrote:
What do you have in mind? I've benn adding some user defined functions
and am thinking of creating a repository for them.
All the so-called window functions from SQL:2003 (aka analytic functions):
"Windowed Tables and Window Functions in SQL"
http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf
Postgresql has also had them for a while. I'd love to see sqlite3 gain
them, but I don't think they can be added efficiently as custom
functions. The engine would need to become window-aware, which is
probably enough work to delay its introduction until a consortium member
decides they need it. That said, the VDBE architecture should make it
significantly easier to implement inside sqlite3 than for most other
engines.
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
