Re: Using results from INSERT ... RETURNING - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Using results from INSERT ... RETURNING
Date
Msg-id 603c8f070910040514o232ab791n234afaf8381015c2@mail.gmail.com
Whole thread Raw
In response to Re: Using results from INSERT ... RETURNING  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Using results from INSERT ... RETURNING  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Marko -

I noticed something a little odd about the new append-plan handling.

rhaas=# explain update parent set c = 1;                             QUERY PLAN
-----------------------------------------------------------------------Update  (cost=0.00..60.80 rows=4080 width=12)
-> Seq Scan on parent  (cost=0.00..31.40 rows=2140 width=10)  ->  Seq Scan on child parent  (cost=0.00..29.40 rows=1940
width=14)
(3 rows)

That may be OK, actually, but it does look a little weird.

...Robert


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Using results from INSERT ... RETURNING
Next
From: Robert Haas
Date:
Subject: Re: Using results from INSERT ... RETURNING