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

Timur Sufiev tsufiev at gmail.com
Tue Aug 25 12:31:18 UTC 2009


>> 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
Thanks, Daniel!
-- 
Timur Sufiev




More information about the postmodern-devel mailing list