Re: About SP's and parameters

in 7.1, there's "EXECUTE" command in plsql, so you can do:

execute 'delete from ' || $1;

-alex

On Thu, 8 Feb 2001, Alfonso Peniche wrote:

> Hi all:
>
> Is there a way to pass a tablename as a parameter to a SP?
>
> I'll try to explain myself. I want to create a SP that can, for
> instance, do a delete from ...... so that any particular application all
>
> it has to do is call the SP sending the table to be deleted.
>
> Right now I have:
>
> CREATE FUNCTION deleteanytable (bpchar)
> returns integer
> as '
> begin
> delete from $1;
>
> return 1;
> end;'
> language 'plpgsql';
>
> If I call it:
> select deleteanytable ( mytable );
>
> I get a message saying
>
> ERROR: Attribute 'mytable' not found
>
> Thanks for your help.
>
> P.S. It would be very interesting if a columnname could also be sent as
> a parameter to the Stored Procedure.
>
>
>
>