On 9 Jul 2017, at 1:44am, Keith Medcalf <kmedc...@dessus.com> wrote:
> I can't visualize what you mean. Something like: > > create view constants (col1, col2) as values (1,1), (1,2); > > seems the most straightforward to me, and allows you to assign column names > to the data. But that’s not SQL syntax, is it ? (Read that in a puzzled voice. I genuinely don’t know.) You’re just using the word VALUE as if it does what you want. I was thinking of a CREATE TABLE command, and a SELECT command with "AS" clauses. Or of something similar with a VIEW. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users