Re: [HACKERS] Arrays broken on temp tables

> No, our code is *not* OK.  It's true that the original example was given
> without a WHERE clause, whereas a practical UPDATE would usually have a
> WHERE clause; but that has nothing to do with whether the planner will
> generate a join or not.  If a join is done then the wrong things will
> happen, WHERE or no WHERE.
> 
> The bottom line here is that we mustn't generate separate RTEs for the
> logical and physical table names.

Are you saying a join on a temp table will not work?  Can you give an
example?


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026