Search Postgresql Archives

Re: table variables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 18, 2006 at 01:16:02PM +0200, Sim Zacks wrote:
> What I am trying to do is write a multi step query, where it would be 
> much much much more efficient to create a temp table, so a single insert 
> and then populate it with update statements.
> The problem is that you can't use a temp table in functions without 
> dynamic execute statements, and those don't work for other parts of the 
> code (besides the fact that they're confusing).

I'm thinking that we should just make temp tables work normally in
functions. Needs no new syntax and is what people expect anyway.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog@xxxxxxxxx>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment: signature.asc
Description: Digital signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux