Re: Text-any concatenation volatility acting as optimization barrier - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Text-any concatenation volatility acting as optimization barrier
Date
Msg-id 28131.1328723634@sss.pgh.pa.us
Whole thread Raw
In response to Re: Text-any concatenation volatility acting as optimization barrier  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 02/08/2012 11:20 AM, Tom Lane wrote:
>> I am going to go ahead and commit the patch with the altered json 
>> results, because IMO it is mere accident that these regression cases 
>> were coming out with "nice" field labels anyway. When and if Andrew 
>> gets the RowExpr cases fixed properly, that will show up as these 
>> cases going back to nicer-looking output.

> I take it this is your way of making me hurry up with that work :-)

Well, right now the behavior is more consistent than it was before;
we would surely have gotten questions about it as it was.  Whether
you find time to improve it or not isn't my concern at the moment.

BTW, the order of the items in the json output doesn't match the column
order of the sub-select, with or without the patch.  This seems ... odd.
Is it intentional?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH] Enable min/max optimization for bool_and/bool_or/every
Next
From: Robert Haas
Date:
Subject: Re: Progress on fast path sorting, btree index creation time