X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id A35C7925DAF for ; Fri, 23 May 2003 01:16:11 -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 51945-06 for ; Fri, 23 May 2003 01:15:37 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by developer.postgresql.org (Postfix) with ESMTP id 10BA0925F71 for ; Thu, 22 May 2003 21:42:29 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id EBF00D61F; Thu, 22 May 2003 18:42:28 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id E1AB05C0F; Thu, 22 May 2003 18:42:28 -0700 (PDT) Date: Thu, 22 May 2003 18:42:28 -0700 (PDT) From: Stephan Szabo To: =?ISO-8859-1?Q?Beno=EEt_Bournon?= Cc: Subject: Re: tablename as attribute in pgplsql In-Reply-To: <3ECCF0D1.8030705@adelis.com> Message-ID: <20030522184108.C51260-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/447 X-Sequence-Number: 13612 On Thu, 22 May 2003, [ISO-8859-1] Beno=EEt Bournon wrote: > DECLARE > usertablename ALIAS FOR $1 ; > userid ALIAS FOR $2 ; > > id_lang BIGINT ; > > var VARCHAR(200) ; > > BEGIN > var :=3D 'client' ; > > SELECT id_language INTO id_lang FROM client WHERE id_user =3D useri= d ; > IF NOT (id_lang =3D 1 OR id_lang =3D 3) THEN > id_lang =3D 1 ; > END IF ; > > RETURN id_lang ; > > END ; > > I want to use client table as a variable > > How could I do Look at the documentation for EXECUTE. Unfortunately using EXECUTE into a variable is a little complicated right now AFAIR because you can't using select ... INTO variable inside the execute, but instead need to use something like for in execute loop.