[postmodern-devel] [S-SQL] Multiple rows in INSERT INTO clause

Daniel White daniel at whitehouse.id.au
Tue Aug 25 12:11:18 UTC 2009


On Tue, 25 Aug 2009 14:12:30 +0400
Timur Sufiev <tsufiev at gmail.com> wrote:

> Is there some way in S-SQL to generate INSERT INTO clauses with multiple
> rows, e.g. "INSERT INTO \"table\" (a, b) VALUES (10, 20), (30, 40)" ?
> Desired sexp format is `(:insert-into table :set a (10 20) b (30 40)),

The functionality already exists, albeit undocumented.

(:insert-rows-into 'table
                   :columns 'a 'b
                   :values '((10 20) (30 40)))

-- 
Daniel White




More information about the postmodern-devel mailing list