About SP's and parameters

Поиск
Список
Период
Сортировка
От Alfonso Peniche
Тема About SP's and parameters
Дата
Msg-id 3A83205B.A4F2E2FC@iteso.mx
обсуждение исходный текст
Ответы Re: About SP's and parameters  (Alex Pilosov <alex@pilosoft.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Varchar Indexing
Следующее
От: Alvar Freude
Дата:
Сообщение: Re: Varchar Indexing, Null Bytes