Re: [GENERAL] Will there be a JSON operator like ->> but returning numeric?

2014-09-23 Thread Tom Lane
Seamus Abshere writes: > 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? I believe we discussed this, along with variants to return

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

2014-09-23 Thread Seamus Abshere
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 -- Se