Yes Bruce, IT IS In the new documentation (7.1 release), but not in previous
versions. If you want me to be specific, it's in the reference manual under
SQL Commands - CREATE TABLE AS.....
Cheers
Bruce Momjian wrote:
> This should be in the docs somewhere. Is it?
>
> > Alfonso Peniche <alfonso@iteso.mx> writes:
> > > In that case, how could I create a temporary table from plpgsql?
> >
> > CREATE [TEMP] TABLE foo AS SELECT ...
> >
> > This is equivalent to SELECT INTO [TEMP] foo in regular SQL, and
> > does not change meaning in plpgsql.
> >
> > regards, tom lane
> >
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026