Re: [HACKERS] JSON NULLs

2013-02-11 Thread Yeb Havinga
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

Re: [HACKERS] JSON NULLs

2013-02-10 Thread Andrew Dunstan
On 02/10/2013 05:43 AM, Yeb Havinga wrote: On 2013-02-08 15:15, Andrew Dunstan wrote: Revised patch attached. The problem also existed with the get*_as_text functions (and their operators). Some additional regression tests are added to test these cases. Hi, I did some minor things with

Re: [HACKERS] JSON NULLs

2013-02-10 Thread Yeb Havinga
On 2013-02-08 15:15, Andrew Dunstan wrote: Revised patch attached. The problem also existed with the get*_as_text functions (and their operators). Some additional regression tests are added to test these cases. Hi, I did some minor things with the patch today. 1. thanks for the work on t

Re: [HACKERS] JSON NULLs

2013-02-06 Thread Andrew Dunstan
On 02/06/2013 02:24 PM, Merlin Moncure wrote: On Wed, Feb 6, 2013 at 1:08 PM, David E. Wheeler wrote: Hackers, While playing with Andrew’s JSON enhancements, I noticed this: david=# select * From json_each_as_text('{"baz": null}'::json); key | value -+--- baz |

Re: [HACKERS] JSON NULLs

2013-02-06 Thread Merlin Moncure
On Wed, Feb 6, 2013 at 1:08 PM, David E. Wheeler wrote: > Hackers, > > While playing with Andrew’s JSON enhancements, I noticed this: > > david=# select * From json_each_as_text('{"baz": null}'::json); > key | value > -+--- > baz | null > > It is returning 'null'::text th

[HACKERS] JSON NULLs

2013-02-06 Thread David E. Wheeler
Hackers, While playing with Andrew’s JSON enhancements, I noticed this: david=# select * From json_each_as_text('{"baz": null}'::json); key | value -+--- baz | null It is returning 'null'::text there, not NULL::text. I had expected the latter, because otherwise it's n