Thanks very much for that David - really appreciate your response - it works like a dream c On Tuesday, 2 October 2012 19:42:59 UTC+1, Chris McDonald wrote: > Hi, > > > > > > If I had a single table targ to insert into I would do an > > > > INSERT INTO targ SELECT thiscol, thatcol, theothercol FROM FOO. > > > > The problem is that I have tables targ1, targ2, targn to insert things into and a nice stored procedure myproc which does the insertion into all 3 tables - problem is that I dont see how I can effectively do > > > > INSERT INTO myproc SELECT thiscol, thatcol, theothercol FROM FOO. > > > > The only way I can work out how to do this is with another stored procedure which allows me to do: > > > > FOR rec IN SELECT thiscol, thatcol, theothercol > > FROM FOO > > LOOP > > PERFORM myproc(rec.thiscol, rec.thatcol, rec.theothercol); > > END LOOP; > > > > But is there a way to do this just in SQL only without resorting to plpgsql or a language like C/Java? > > > > thanks > > > > c -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
