Re: [GENERAL] plpgsql and schema

2005-06-23 Thread Michael Fuhr
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

Re: [GENERAL] plpgsql and schema

2005-06-23 Thread Michael Fuhr
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