Dynamic DDL - Mailing list pgsql-general

From Ketema
Subject Dynamic DDL
Date
Msg-id 1176755863.226764.170230@d57g2000hsg.googlegroups.com
Whole thread Raw
Responses Re: Dynamic DDL  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
create or replace function schema.insert_function(_schema text, _table
text) returns integer
as
$BODY$
declare
    _affected integer;
begin
    set search_path to _schema;
    insert into _table (columns) values(vals);
return 0;
end;
$BODY$ language plpgsql;

is there any whay to get the functionality of above to work with out
have to build a string and use the execute function?


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: concatenating setof functions
Next
From: garry saddington
Date:
Subject: delete with self join