Re: using a stored proc that returns a result set in a complex SQL stmt - Mailing list pgsql-performance

From Marcin Stępnicki
Subject Re: using a stored proc that returns a result set in a complex SQL stmt
Date
Msg-id 179149fe0710162232l26083487nb3155525c7925a96@mail.gmail.com
Whole thread Raw
In response to Re: using a stored proc that returns a result set in a complex SQL stmt  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-performance
On 10/16/07, Heikki Linnakangas <heikki@enterprisedb.com> 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 what requirement you're referring to.

I think he means creating temporary tables in stored procedures as
described for example here ->
http://svr5.postgresql.org/pgsql-sql/2007-01/msg00117.php . From what
I see at http://www.postgresql.org/docs/8.3/static/release-8-3.html
the EXECUTE workaround is no longer necessary as plan invalidates upon
table schema changes.

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Vacuum goes worse
Next
From: Stéphane Schildknecht
Date:
Subject: Re: Vacuum goes worse