don't know how to get SELECT

Hi!

i have some problems with plpgsql. Here is my function


create or replace function rm_cat(varchar,int) returns boolean as '
declare
        table alias for $1;
        id    alias for $2;
        data   RECORD;
begin
      ******************************************************************
       SELECT INTO data lft,rgt FROM d_categories WHERE id_category=id;
       ******************************************************************
      IF NOT FOUND THEN
              RAISE EXCEPTION ''id % does not exist'',id;
              return 0;
      end if;

      -- deleting the leftmost node does not lower lft for all
         execute ''update '' || quote_ident(table) || '' set level=level-1 where lft > ''  || data.lft || ''and rgt <
''|| data.rgt || '';''; 
         execute ''update '' || quote_ident(table) || '' set lft=lft-1 where lft >= '' || data.lft || '';'';
         execute ''update '' || quote_ident(table) || '' set lft=lft-1 where lft >= '' || data.rgt || '';'';
         execute ''update '' || quote_ident(table) || '' set rgt=rgt-1 where rgt >= '' || data.lft || '';'';
         execute ''update '' || quote_ident(table) || '' set rgt=rgt-1 where rgt >= '' || data.rgt || '';'';
         execute ''delete from '' || quote_ident(table) || '' where id_category = '' || id || '';'';
      return 1;
end;
'language 'plpgsql';


My problems is in line wraped with ***. What i want is that
SELECT have to be dinamyc because i want with an argument to
saj for what table do this select. I tried many ways and i
think i don't understand something. Can somebody help me
solve this.



--
bye,
 Uros                          mailto:uros.gruber@sir-mag.com