Received: from sysadmin.chi.wdr.com (sysadmin.chi.ubswarburg.com [146.180.1.66]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4L8sRA12244 for ; Mon, 21 May 2001 04:54:27 -0400 (EDT) (envelope-from devin@sysadmin.chi.wdr.com) Received: from devin by sysadmin.chi.wdr.com with local (Exim 3.12 #2) id 151lS4-0000zR-00; Mon, 21 May 2001 03:54:08 -0500 Date: Mon, 21 May 2001 03:54:02 -0500 (CDT) From: Tod McQuillin X-X-Sender: To: Bruno Boettcher cc: Subject: Re: how to check presence of a function and set permissions? In-Reply-To: <20010521103333.N15377@erm1.u-strasbg.fr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200105/222 X-Sequence-Number: 3039 On Mon, 21 May 2001, Bruno Boettcher wrote: > since i am now destroying and recreating my functions at every request > (due to the fact that pl/psql can't cope with dynamic table names, I don't know about the rest of your question but I believe PostgreSQL supports dynamic queries in plpgsql since v7.1 -- EXECUTE 'SELECT * FROM ' || table_name || ' WHERE whatever'; However, I do not see it in the documentation, so now I'm not 100% certain. -- Tod McQuillin