On 01/31/2013 11:20 PM, Andrew Dunstan wrote:
I'm happy to take opinions about this, and I expected
some bikeshedding, but your reaction is contrary to
everything others have told me. Mostly they love the operators.
What I would really like is if we extended postgresql core and made
a few more constructs definable as overloadable operator:
1) array / dictionary element lookup
a[b]
CREATE OPERATOR [] (...)
2) attribute lookup
a.b
CREATE OPERATOR . (...)
then you could make json lookups either step-by-step using
CREATE OPERATOR [] (
PROCEDURE = json_array_lookup, LEFTARG = json, RIGHTARG = int)
and
CREATE OPERATOR [] (
PROCEDURE = json_dict_lookup, LEFTARG = json, RIGHTARG = text)
fourthname = myjson[4]['name']
or perhaps a single
CREATE OPERATOR [] (
PROCEDURE = json_deep_lookup, LEFTARG = json, RIGHTARG = VARIADIC
"any")
fourthname = myjson[4, 'name']
though I suspect that we do not support type VARIADIC "any" in operator
definitions
---------
Hannu
I guess that '~>' and '~>>' would work as well as '->' and '->>'.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
