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 Malone, Dave

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

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

[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

Re: [HACKERS] JSON NULLs

2013-02-06 Thread Merlin Moncure
On Wed, Feb 6, 2013 at 1:08 PM, David E. Wheeler da...@justatheory.com 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

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 da...@justatheory.com wrote: Hackers, While playing with Andrew’s JSON enhancements, I noticed this: david=# select * From json_each_as_text('{baz: null}'::json); key | value