PLPGSQL function schema or table parameter - Mailing list pgsql-general

From Sidnei de Souza
Subject PLPGSQL function schema or table parameter
Date
Msg-id 431C7FC7.3070508@cria.org.br
Whole thread Raw
Responses Re: PLPGSQL function schema or table parameter
List pgsql-general
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
      select id into result from mySchema.myTable where...
      return result;
End;
' language plpgsql;

Sorry if this issue has already been addressed before but I can't find
any objective comments on this.
Thanks.
sidnei

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: remote connection, web hosting, IP adress
Next
From: Chris Browne
Date:
Subject: Re: More statistics?