Re: [PERFORM] using a stored proc that returns a result set in a complex SQL stmt

2007-10-16 Thread Marcin Stępnicki
On 10/16/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > > The only reason I am going down this road is because of the difficulty of > > using temp tables ( i.e. needing to execute a SQL string). Does anyone know > > if this requirement may be removed in the near future? > > I don't understand

Re: [PERFORM] using a stored proc that returns a result set in a complex SQL stmt

2007-10-16 Thread Heikki Linnakangas
chrisj wrote: > I am trying to decide between using a temporary table or a stored proc that > returns a result set to solve a fairly complex problem, and was wondering if > Postres, when it sees a stored proc reference in a SQL, is smart enough to, > behind the scenes, create a temporary table with

[PERFORM] using a stored proc that returns a result set in a complex SQL stmt

2007-10-16 Thread chrisj
Hi, I am trying to decide between using a temporary table or a stored proc that returns a result set to solve a fairly complex problem, and was wondering if Postres, when it sees a stored proc reference in a SQL, is smart enough to, behind the scenes, create a temporary table with the results of