Will there be a JSON operator like ->> but returning numeric?

From: Seamus Abshere <seamus(at)abshere(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Will there be a JSON operator like ->> but returning numeric?
Date: 2014-09-23 15:56:15
Message-ID: 5421981F.8030204@abshere.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

I've got use cases like

> array_remove(array_agg((a->>'b')::float), NULL)

It would be nice to replace (a->>'b')::float with something like

> a->^'b'

that directly returned a numeric... is that in the cards?

Thanks,
Seamus

--
Seamus Abshere, SCEA
https://github.com/seamusabshere

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Lenski 2014-09-23 16:26:12 Re: Where art thou, plpython2.dll? (EDB installer)
Previous Message Seamus Abshere 2014-09-23 15:47:39 Unexpected syntax error when using JSON -> in 9.3.5