Message-ID: <441AF775.7060006@encs.concordia.ca>
Date: Fri, 17 Mar 2006 12:52:53 -0500
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: in PlPgSQL function, how to use variable in a "select ... into ..
	where " query
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

In pl/pgsql (postgresql 8.01), how to use variables in select .. into .. 
command

CREATE OR REPLACE FUNCTION test(VARCHAR) RETURNS VARCHAR AS $$
DECLARE
   var1                           ALIAS FOR $1;                          
   cm_tableName           tableA.col1%TYPE; 
   T1                              VARCHAR := 'sourceTable';
   query_value               VARCHAR ;
BEGIN

   SELECT col2 INTO cm_tableName FROM  T1  WHERE col1 = var1 ;
   EXECUTE query_value;

  
   RETURN cm_tableName;
 END;
$$ language 'plpgsql' IMMUTABLE STRICT;

select test('abc');

Failed.


Also, tried "SELECT col2 INTO cm_tableName FROM ||  T1  WHERE col1 =  || 
var1 " and
"SELECT col2 INTO cm_tableName FROM ||  T1 ||  WHERE col1 =  || var1"

Failed as well.

T1 and var1 both are variables, may I how to use variables in a "select 
... into " query please?

Thanks a lot,
Ying