Thanks Ryan.
Thank you very much for the detailed analysis on how the column names are
arrived at.
Presumably the column names "",":1",":2",... will be stable in future. I
use them frequently in the following pattern.
SELECT custom_aggregate("",":1") FROM (VALUES (1,2),(3,4));
Or, with slightly more readable [column] delimiters:
SELECT custom_aggregate([],[:1]) FROM (VALUES (1,2),(3,4));
The ideal of course would be a VALUE clause which supported a full
anonymous table syntax mentioned in reply to Simon:
SELECT custom_aggregate(c1,c2) FROM (VALUES (1,2),(3,4) AS (c1,c2));
I'm looking forward to reading more comments on this topic.
Peter
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
