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 97F2592546C for ; Sun, 25 May 2003 12:07:28 -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 42039-01 for ; Sun, 25 May 2003 12:07:24 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by developer.postgresql.org (Postfix) with ESMTP id 8C85E92545E for ; Sun, 25 May 2003 12:07:24 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 0CC95D61B; Sun, 25 May 2003 09:07:18 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 0327A5C10; Sun, 25 May 2003 09:07:17 -0700 (PDT) Date: Sun, 25 May 2003 09:07:17 -0700 (PDT) From: Stephan Szabo To: =?ISO-8859-1?Q?Beno=EEt_Bournon?= Cc: Subject: Re: tablename as attribute in pgplsql In-Reply-To: <3ECDCFFB.1090808@adelis.com> Message-ID: <20030525090626.I35061-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/487 X-Sequence-Number: 13652 On Fri, 23 May 2003, [ISO-8859-1] Beno=EEt Bournon wrote: > It is not possible tu use a specific argument ? type table or tablename ? Not for the table name in a direct statement like select foo from variable; > execute is not runnig Define not running. > Stephan Szabo a =E9crit: > > >On Thu, 22 May 2003, [ISO-8859-1] Beno?t 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 use= rid ; > >> 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. > > > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 5: Have you checked our extensive FAQ? > > > >http://www.postgresql.org/docs/faqs/FAQ.html > > > > > > >