Re: Incremental results from libpq

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