Re: JSON NULLs

On 2013-02-10 16:03, Andrew Dunstan wrote:
> On 02/10/2013 05:43 AM, Yeb Havinga wrote:
>> 3. I was wondering how to access the first author from this json 
>> snippet:
>>
>> {
>>  "id": "QZr82w_eSi8C",
>>  "etag": "KZ+JsrkCdqw",
>>  "volumeInfo": {
>>   "title": "Heads Up Software Construction",
>>   "authors": [
>>    "Dan Malone",
>>    "Dave Riles"
>>   ],
>>
>>
>
> try:
>
>    json_get_path_as_text(document,  'volumeInfo', 'authors', '0')
>
>
> There are other ways to spell this, too:
>
>    json_get_path_as_text(document,  variadic
>    '{volumeInfo,authors,0}'::text[])
>
>
> or
>
>    document->>'{volumeInfo,authors,0}'::text[]

That works very nice, thanks!
>
> I'm actually wondering if we should use different operator names for 
> the get_path*op functions so we wouldn't need to type qualify the path 
> argument. Maybe ?> and ?>> although I'm reluctant to use ? in an 
> operator given the recent JDBC discussion. Or perhaps #> and #>>.

different operator name: +1.

thanks
Yeb