Re: [PERFORM] assignment vs SELECT INTO

2014-11-03 Thread Andrew Dunstan
On 11/03/2014 03:24 PM, Tom Lane wrote: Andrew Dunstan writes: andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop select 'a','b',i into r.x,r.y,r.z; end loop; end; $x$; DO Time: 63731.434 ms andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop

Re: [PERFORM] assignment vs SELECT INTO

2014-11-03 Thread Matheus de Oliveira
On Mon, Nov 3, 2014 at 6:00 PM, Andrew Dunstan wrote: >andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop >select 'a','b',i into r.x,r.y,r.z; end loop; end; $x$; >DO >Time: 63731.434 ms >andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop r >:= (

Re: [PERFORM] assignment vs SELECT INTO

2014-11-03 Thread Tom Lane
Andrew Dunstan writes: > andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop > select 'a','b',i into r.x,r.y,r.z; end loop; end; $x$; > DO > Time: 63731.434 ms > andrew=# do $x$ declare r abc; begin for i in 1 .. 1000 loop r > := ('a','b',i); end loop; end;