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