[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