> 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
