Home > mailing lists

Re: PLPGSQL: Using SELECT INTO and EXECUTE - Mailing list pgsql-general

From	Tom Lane
Subject	Re: PLPGSQL: Using SELECT INTO and EXECUTE
Date	June 12, 2001 23:24:24
Msg-id	16694.992391848@sss.pgh.pa.us Whole thread Raw
In response to	PLPGSQL: Using SELECT INTO and EXECUTE (Michael Dunn <michael@2cactus.com>)
Responses	PLPGSQL: Using Transactions and locks (Allan Kamau <hugebirdwings@yahoo.com>)
List	pgsql-general

Tree view

Michael Dunn <michael@2cactus.com> writes:
> Can EXECUTE handle a SELECT INTO statement within a plpgsql function.

SELECT INTO doesn't mean the same thing in plpgsql as it does in regular
SQL.  Use CREATE TABLE AS, instead.

            regards, tom lane

pgsql-general by date:

From: Tatsuo Ishii
Date: 12 June 2001, 23:07:18
Subject: Re: Big5 contains '\'

From: Steve Micallef
Date: 12 June 2001, 23:40:24
Subject: Unix time stamp function?

Re: PLPGSQL: Using SELECT INTO and EXECUTE - Mailing list pgsql-general

Previous

Next