plpgsql - Postgresql CREATE TABLE AS INSERT RETURNING -
i trying perform like
create temp table tblname ( insert tbl2 select(1,1) returning a,b );
but i've got error: syntax error @ or near "insert";
is possible combine create table select , insert select returning clauses?
create temp table tblname ( insert tbl2 (a, b) select 1, 1 returning a,b ) select a, b
Comments
Post a Comment