Re: [GENERAL] PLPGSQL function schema or table parameter

2005-09-05 Thread A. Kretschmer
am 05.09.2005, um 14:26:31 -0300 mailte Sidnei de Souza folgendes: > Is it possible to pass a table name and/or schema name to a plpgsql > function? Yes. > How can I use them in the code? Which Types to use for each of the > parameters? varchar. > > E.g. > > create or replace function MyTe

[GENERAL] PLPGSQL function schema or table parameter

2005-09-05 Thread Sidnei de Souza
Is it possible to pass a table name and/or schema name to a plpgsql function? How can I use them in the code? Which Types to use for each of the parameters? E.g. create or replace function MyTest (mySchema WhichType?, myTable WhichType?) returns integer as ' declare result integer; Begin