X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 9FAA492352E
	for <pgsql-sql@postgresql.org>; Thu, 22 May 2003 12:56:04 -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 31934-02 for <pgsql-sql@postgresql.org>;
	Thu, 22 May 2003 12:55:32 -0400 (EDT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by developer.postgresql.org (Postfix) with ESMTP id 3CA2B925832
	for <pgsql-sql@postgresql.org>; Thu, 22 May 2003 11:46:13 -0400 (EDT)
Received: from adelis.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP id CB449791F6
	for <pgsql-sql@postgresql.org>; Thu, 22 May 2003 17:38:57 +0200 (CEST)
Message-ID: <3ECCF0D1.8030705@adelis.com>
Date: Thu, 22 May 2003 17:46:25 +0200
From: =?ISO-8859-1?Q?Beno=EEt_Bournon?= <benoit.bournon@adelis.com>
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: tablename as attribute in pgplsql
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/426
X-Sequence-Number: 13591

DECLARE
   usertablename ALIAS FOR $1 ;
   userid ALIAS FOR $2 ;

   id_lang BIGINT ;

   var VARCHAR(200) ;

BEGIN
      var := 'client' ;

      SELECT id_language INTO id_lang FROM client WHERE id_user = userid ;
      IF NOT (id_lang = 1 OR id_lang = 3) THEN
          id_lang = 1 ;
      END IF ;

      RETURN id_lang ;

END ;

I want to use client table as a variable

How could I do