Re: don't know how to get SELECT

Use the EXECUTE command.

This allows the execution of dynamic queries

EXECUTE ''UPDATE ''||table||'' SET id = ''||id||''WHERE something =
something'';

This is just an example but it shows how to execute dynamic queries

HTH

Darren Ferguson

On Mon, 13 May 2002, Uros Gruber wrote:

> 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(dot)gruber(at)sir-mag(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>