Re: machine-readable explain output v4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: machine-readable explain output v4
Date: 2009-08-10 16:47:37
Message-ID: 12204.1249922857@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Mon, Aug 10, 2009 at 12:13 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Uh, no, I see one container and a property. If we do just
>>
>> <Filter><Expr>(f1 &gt; 0)</Expr></Filter>
>>
>> then where do we put additional information about the expression
>> when the time comes?

> I would assume you would just write:

> <Filter><Text>(f1 &gt; 0)</Text><Other-Stuff>thing!</Other-Stuff></Filter>

Perhaps the issue would be clearer in JSON notation. We have

"Filter": "(f1 > 0)"

What I suggest is

"Filter": { "Text": "(f1 > 0)" }

I don't see where you're going to shoehorn in any additional information
without the container, and once you have the container you need to name
the property, no?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2009-08-10 16:54:23 Re: Patch for 8.5, transformationHook
Previous Message Robert Haas 2009-08-10 16:39:00 Re: machine-readable explain output v4