Re: [SQL] We all are looped on Internet: request + transport = invariant

2007-05-01 Thread Dmitry Turin
Good day, Joe. Joe and other respected comrades, don't be angry, when my letter will be late. This is caused by technical schedule of our internet. J> ... and C, PHP, Python, etc., to create an application to input J> and maintain the data. Question remains open: for what people must learn php,

Re: [SQL] Dynamic prepare possible in plpgsql?

2007-05-01 Thread Jonah H. Harris
On 5/1/07, Collin Peters <[EMAIL PROTECTED]> wrote: Is it faster to use PREPARE for the various INSERT statements inside a plpgsql function? Perhaps I am wrong and it does its PREPARE work when the function is parsed. IIRC, PLpgSQL automagically prepares each statement behind the scenes on the

Re: [SQL] Dynamic prepare possible in plpgsql?

2007-05-01 Thread Collin Peters
I have a plpgsql function which is doing a loop over one table of user data and then inserting that data in various tables. Example: loop over user table (temp data) insert into users1 table insert into users2 table etc end loop Is it faster to use PREPARE for the various INSERT state