plpgsql and schema
От | Roberto Pellagatti |
---|---|
Тема | plpgsql and schema |
Дата | |
Msg-id | 42B996E0.2050808@ropelsoftware.fastwebnet.it обсуждение исходный текст |
Ответы |
Re: plpgsql and schema
|
Список | pgsql-general |
The problem: I've two tables, both called "test" on two different schemas, let's say schema1 and schema2. I need to write a function like (just a simple example) CREATE OR REPLACE FUNCTION foo() RETURNS int4 AS $BODY$ declare num int4; begin select into num count(*) from test; return num; end; $BODY$ LANGUAGE 'plpgsql' VOLATILE; I need something like: SET search_path = schema1,public; select foo(); -- get the number of rows of schema1.test SET search_path = schema2,public; select foo(); -- get the number of rows of schema2.test The problem is that i get always the number of rows from the table in the schema that was current when I created the function. How can I obtain what I need ?? I cannot write 2 different functions (my db is really more complex, with lots of functions and triggers that need this kind of access). Thanks to everybody Roberto
В списке pgsql-general по дате отправления: