From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Beckstette <mbeckste@TechFak.Uni-Bielefeld.DE>
Cc: pgsql-sql@postgresql.org
Subject: Re: Creation of a table with dynamic name from inside a pgpsql function
Date: Tue, 28 May 2002 13:33:54 -0400
Message-ID: <11520.1022607234@sss.pgh.pa.us> (raw)
In-Reply-To: <1020528175341.ZM17959@sirari.TechFak.Uni-Bielefeld.DE>
References: <1020528175341.ZM17959@sirari.TechFak.Uni-Bielefeld.DE>
"Michael Beckstette" <mbeckste@TechFak.Uni-Bielefeld.DE> writes:
> query_string:= ''CREATE TABLE temp1 AS SELECT * FROM ''||
> quote_ident(table_name) || '' WHERE (hsp_rank=1 AND hsp_evalue<=0.001)'';
> RAISE NOTICE ''Query: %'',query_string;
> EXECUTE query_string;
> prod2_db=# select test('blasthits_obj_174_q122_db123');
> NOTICE: Query: CREATE TABLE temp1 AS SELECT * FROM
> blasthits_obj_174_q122_db123 WHERE (hsp_rank=1 AND hsp_evalue<=0.001)
> ERROR: EXECUTE of SELECT ... INTO is not implemented yet
Update to 7.2.1. The above should be allowed, but was mistakenly
rejected by 7.2.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, mbeckste@TechFak.Uni-Bielefeld.DE
Subject: Re: Creation of a table with dynamic name from inside a pgpsql function
In-Reply-To: <11520.1022607234@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox