On 2012-10-02, Chris McDonald <chrisjonmcdonald@xxxxxxxxx> 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. see the chapter on partitioning for info on how to write a rule or trigger to do it with syntax like that. However with what you already have you you can do this: SELECT myproc(thiscol, thatcol, theothercol) FROM FOO; -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
