Quick Links

Re: PLPGSQL: Using SELECT INTO and EXECUTE

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Michael Dunn <michael(at)2cactus(dot)com>
Cc:	Postgres <pgsql-general(at)postgresql(dot)org>
Subject:	Re: PLPGSQL: Using SELECT INTO and EXECUTE
Date:	2001-06-13 00:24:08
Message-ID:	16694.992391848@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Michael Dunn <michael(at)2cactus(dot)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

Re: PLPGSQL: Using SELECT INTO and EXECUTE at 2001-06-13 06:21:26 from Michael Dunn
PLPGSQL: Using Transactions and locks at 2001-06-13 09:36:15 from Allan Kamau

	From	Date	Subject
Next Message	Steve Micallef	2001-06-13 00:38:30	Unix time stamp function?
Previous Message	Tatsuo Ishii	2001-06-13 00:03:43	Re: Big5 contains '\'