On Thu, 9 Feb 2006 17:57:03 -0500, "Gonzalo Villegas" <[EMAIL PROTECTED]> wrote: > > > Hi all, > > I'm trying to insert more than one t-uple in a single sql query. Just like > > copy table (field1,field2,...) from .... > > It must be something like > > insert into table (field1,field2,...) values (v1,v2,...),(b1,b2,...), > (c1,c2,...)
insert into table (field1,field2) select v1,v2 union all select b1,b2 union all select c1,c2 klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
