On 2012-10-02, Chris McDonald <chrisjonmcdon...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
