Re: PATCH: Add hstore_to_json() - Mailing list pgsql-hackers

From Robert Haas
Subject Re: PATCH: Add hstore_to_json()
Date
Msg-id 603c8f070912301123x25e4073eh31f7bd71f2179784@mail.gmail.com
Whole thread Raw
In response to Re: PATCH: Add hstore_to_json()  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: PATCH: Add hstore_to_json()  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Wed, Dec 30, 2009 at 1:23 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
> I think we are getting the cart way before the horse. I'd like to see at
> least the outline of an API before we go any further. JSON is, shall we say,
> lightly specified, and doesn't appear to have any equivalent to XPath and
> friends, for example. How will we extract values from a JSON object? How
> will we be able to set values inside them? In ECMAScript it's not a problem,
> because the objects returned are just like any other objects, but that's not
> the case here. These are the sorts of questions we need to answer before we
> look at any implementation details, I think.

I think the idea that Peter was proposing was to start by creating a
type that doesn't necessarily have a lot of operators or functions
associated with it, with the thought of adding those later.  It would
still need to validate the input, of course.

Anyhow, that might be a bad way to approach the problem, but I think
that's how we got here.

...Robert


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Thoughts on statistics for continuously advancing columns
Next
From: Robert Haas
Date:
Subject: Re: Hot Standy introduced problem with query cancel behavior