Re: Creation of a table with dynamic name from inside a pgpsql function - Mailing list pgsql-sql

"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