Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1FFa4x00403 for ; Thu, 15 Feb 2001 10:36:04 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1FFZw902398; Thu, 15 Feb 2001 10:35:58 -0500 (EST) To: Alfonso Peniche cc: pgsql-general@postgresql.org Subject: Re: Re: temp table creation In-reply-to: <3A8BF521.BDE3BC69@iteso.mx> References: <3A8B2C47.465BBF9@iteso.mx> <440.982202091@sss.pgh.pa.us> <3A8BF521.BDE3BC69@iteso.mx> Comments: In-reply-to Alfonso Peniche message dated "Thu, 15 Feb 2001 09:26:25 -0600" Date: Thu, 15 Feb 2001 10:35:58 -0500 Message-ID: <2395.982251358@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/715 X-Sequence-Number: 4611 Alfonso Peniche 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