(Hopefully this works.) > How about something like: > > with t(a, b) as (values (1, 1), (2, 2)) select a, b from t;
Yeah, CTEs are an obvious alternative. I mostly request this AS t(n) feature because I have had some otherwise-portable PostgreSQL queries that I needed to tweak for SQLite. The thing with PostgreSQL is that until very recently CTEs would generally perform worse than sub-queries, so a lot of people avoided it. My SQLite version used CTEs with no issues, but still I thought I might as well request the feature, to improve compatibility. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
