Re: Creation of a table with dynamic name from inside a pgpsql function

"Michael Beckstette" <mbeckste(at)TechFak(dot)Uni-Bielefeld(dot)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