Received: from iteso.mx (iteso.mx [148.201.1.4])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1FFQXx98912
	for <pgsql-general@postgresql.org>;
	Thu, 15 Feb 2001 10:26:33 -0500 (EST)
	(envelope-from alfonso@iteso.mx)
Received: from iteso.mx (alfonso@[148.201.112.30])
	by iteso.mx (8.11.1/8.11.1) with ESMTP id f1FFQR750461
	for <pgsql-general@postgresql.org>;
	Thu, 15 Feb 2001 09:26:27 -0600 (CST)
	(envelope-from alfonso@iteso.mx)
Message-ID: <3A8BF521.BDE3BC69@iteso.mx>
Date: Thu, 15 Feb 2001 09:26:25 -0600
From: Alfonso Peniche <alfonso@iteso.mx>
Organization: Iteso University
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17 i686)
X-Accept-Language: en
MIME-Version: 1.0
CC: pgsql-general@postgresql.org
Subject: Re: temp table creation
References: <3A8B2C47.465BBF9@iteso.mx> <440.982202091@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200102/713
X-Sequence-Number: 4609

In that case, how could I create a temporary table from plpgsql? (I don't
want to use select into table.......)

Thanx

Tom Lane wrote:

> Alfonso Peniche <alfonso@iteso.mx> writes:
> > What's wrong with this function? The syntax is supposed to be right,
> > isn't it?
>
> No, it isn't right, not for plpgsql.  SELECT INTO means something
> different to plpgsql than it does in normal Postgres SQL.
>
>                         regards, tom lane