Received: from mail2.rdc2.bc.home.com (mail2.rdc2.bc.home.com [24.2.10.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f251Zbx99277 for ; Sun, 4 Mar 2001 20:35:37 -0500 (EST) (envelope-from pozix@home.com) Received: from elrond.home.com ([24.113.128.171]) by mail2.rdc2.bc.home.com (InterMail vM.4.01.03.00 201-229-121) with ESMTP id <20010305013531.VVJQ585.mail2.rdc2.bc.home.com@elrond.home.com>; Sun, 4 Mar 2001 17:35:31 -0800 Message-Id: <5.0.2.1.0.20010304173302.02a55f00@mail.rchmd1.bc.wave.home.com> X-Sender: pozix@mail.rchmd1.bc.wave.home.com X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Sun, 04 Mar 2001 17:38:03 -0800 To: josh@agliodbs.com, pgsql-sql@postgresql.org From: Gerald Gutierrez Subject: Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT In-Reply-To: <3AA2E085.4A2C8C21@agliodbs.com> References: <5.0.2.1.0.20010303202117.02a09d50@mail.rchmd1.bc.wave.home.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200103/44 X-Sequence-Number: 1689 I've found the discussion to which you have referred: http://www.postgresql.org/mhonarc/pgsql-sql/2001-02/msg00157.html but was unable to find the documentation for the EXECUTE command. From the discussion it seemed to me that doing an "INSERT" into a table of variable name cannot be done now. It is unfortunate, but I guess nothing can be done about it now. At 04:40 PM 3/4/2001 -0800, you wrote: >Mr. Gutierrez: > > The EXECUTE command is what you need. Please see the development >documentation, and the list archives for January-Early Feb. > > -Josh Berkus