Variable Substitution for table name - Mailing list pgsql-general

From Samuel J. Sutjiono
Subject Variable Substitution for table name
Date
Msg-id 00e901c1cd34$edd88cb0$110a010a@headquarters.wcgroup.com
Whole thread Raw
Responses Re: Variable Substitution for table name  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Hello all,
 
Does anybody know whether I can do variable substitution in PostgreSQL function ???
 
create function Test(text) returns text as '
DECLARE  
  NewView ALIAS for $1;
       
BEGIN
 
 For rec_set IN SELECT DeptdID, VendorName
 from NewView where  (DeptID = iDeptID)
 
I appreciate any help very much.
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get the name of a table's primary key?
Next
From: Tom Lane
Date:
Subject: Re: problem with array of boxes