Re: [HACKERS] WIP patch for multiple column assignment in UPDATE

2014-06-23 Thread Robert Haas
On Thu, Jun 19, 2014 at 9:37 AM, Tom Lane wrote: > Pavel Stehule writes: >> I did some tests and It looks so it allows only some form of nested loop. > > [ shrug... ] It's a subplan. One evaluation per outer row is what > people are expecting. Is it theoretically possible to convert a construc

Re: [HACKERS] WIP patch for multiple column assignment in UPDATE

2014-06-19 Thread Pavel Stehule
2014-06-19 15:37 GMT+02:00 Tom Lane : > Pavel Stehule writes: > > I did some tests and It looks so it allows only some form of nested loop. > > [ shrug... ] It's a subplan. One evaluation per outer row is what > people are expecting. > ok regards Pavel > > regards, t

Re: [HACKERS] WIP patch for multiple column assignment in UPDATE

2014-06-19 Thread Tom Lane
Pavel Stehule writes: > I did some tests and It looks so it allows only some form of nested loop. [ shrug... ] It's a subplan. One evaluation per outer row is what people are expecting. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq

Re: [HACKERS] WIP patch for multiple column assignment in UPDATE

2014-06-19 Thread Pavel Stehule
Hello I did some tests and It looks so it allows only some form of nested loop. postgres=# explain (analyze, timing off, buffers) update a1 set b = (select b from a2 where a1.a = a2.a); QUERY PLAN --