Home > mailing lists

insert values from a ROW object - Mailing list pgsql-sql

From	Michael Moore
Subject	insert values from a ROW object
Date	September 23, 2016 00:43:01
Msg-id	CACpWLjMR2-1XOMd7y6WbHribWUvNrxq42jxeDbv7CVsve1H9CQ@mail.gmail.com Whole thread Raw
Responses	Re: insert values from a ROW object Re: insert values from a ROW object Re: insert values from a ROW object
List	pgsql-sql

for a in select * from temp_rslt

loop

insert into final_rslt select row(a.*);

end loop;

I want to do something like the above. I don't want to have to name each 'a.' variable.

Is it possible?

TIA

Mike

From: Tom Lane
Date: 20 September 2016, 17:47:59
Subject: Re: PostgreSQL 9.5 operator precedence

From: Michael Moore
Date: 23 September 2016, 00:44:11
Subject: Re: insert values from a ROW object