how can I do the following in plpgsql? insert multiple rows in a table get the ids (serial) into a temp table (not the client) for one row it will be like this insert into mytable(mycolumn)values(123)returning id into some_variable;
now for multiple rows (using insert select) it will be like insert into mytable(mycolumn) select other_column from other_table returning id into ???