Re: [sqlite] Idea: defining table-valued functions directly in SQL

Hello, The new example is clear, and therefore also raises a question: > CREATE TABLE people (name, age); > INSERT INTO people VALUES ('Bob', 33), ('Jen', 19), ('Liz', 30); > > CREATE VIEW older PARAMETERS (name, otherName) AS > SELECT t1.age > t2.age AS older > FROM people AS t1 WHERE t1.name

Re: [sqlite] SQLite .dump

Simon Slavin wrote: > I'm sorry, but I don't see a question in your post. As intended. It was just a statement based on observation, with regard to SQLite .dump, my GUI dump, and other database dump outputs. MySQL also uses a short version without specifying column names, but does quotes