On Thu, Jun 23, 2005 at 09:33:27AM -0600, Michael Fuhr wrote:
>
> http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
> Note what the documentation says about not being able to get the
> result of an EXECUTE query directly. A couple of workarounds
On Wed, Jun 22, 2005 at 06:50:40PM +0200, Roberto Pellagatti wrote:
>
> 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.
PL/pgSQL caches its query plans, so subsequent calls to the function
use the plan created on th
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
