On 10/16/07, Heikki Linnakangas <heikki@xxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
