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

From Robert Haas
Subject Re: Using results from INSERT ... RETURNING
Date
Msg-id 603c8f070910040515j5b7bc050k60472316b2432108@mail.gmail.com
Whole thread Raw
In response to Re: Using results from INSERT ... RETURNING  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Sun, Oct 4, 2009 at 8:14 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> 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.

Argh.  Nevermind.  It was like that before.

Sigh.

...Robert


pgsql-hackers by date:

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