Re: About SP's and parameters - Mailing list pgsql-general

From Alfonso Peniche
Subject Re: About SP's and parameters
Date
Msg-id 3A8341D5.F8B4C8E6@iteso.mx
Whole thread Raw
In response to Re: About SP's and parameters  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-general
And where can I find information about EXECUTE and other new
features/instructions (I haven't found anything in the online manual)?

Alex Pilosov wrote:

> 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.
> >
> >
> >
> >


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Auto-timestamp generator (attached)
Next
From: Joseph Shraibman
Date:
Subject: Re: Auto-timestamp generator (attached)