X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 4742E9256E3 for ; Tue, 27 May 2003 08:07:13 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 40378-09 for ; Tue, 27 May 2003 08:06:17 -0400 (EDT) Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102]) by developer.postgresql.org (Postfix) with ESMTP id 798C7925A10 for ; Tue, 27 May 2003 08:06:07 -0400 (EDT) Received: from adelis.com (ben.adelis.net [195.115.171.16]) by neptune.adelis.net (Postfix) with ESMTP id C25857919B for ; Tue, 27 May 2003 13:46:38 +0200 (CEST) Message-ID: <3ED351D5.3060408@adelis.com> Date: Tue, 27 May 2003 13:53:57 +0200 From: =?ISO-8859-1?Q?Beno=EEt_Bournon?= User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.2.1) Gecko/20030225 X-Accept-Language: fr, en-us, en, ja MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How can I use a name of table in attribute of function, I try PREPARE ... Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/593 X-Sequence-Number: 13758 I can do that on PostgreSQL 7.3 ?? Is it possible to do that ? or must I upgrade my server ?? PREPARE q1(text) FROM SELECT * FROM pg_tables WHERE tablename = $1 ; EXECUTE q1 USING 'client' ; DEALLOCATE q1 ;