Goulet, Dick wrote:
> Alvaro,
>
> You are quite correct, which is functionally the only
> difference. Personally I don't think that really amounts to "a hill of
> beans". The functionality is the same, even if the syntax is a touch
> different. Course, I didn't get a chance to tinker with this, but in
> Oracle a global temp table can have indexes and constraints. Is the
> same true in Postgresql?? I've found it to be a performance improver
> where your loading the temp table with thousands of rows.
Sure, you can create TEMPORARY anything, and because each backend has
its own table, performance is better.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073
