Postgres Pro
Downloads
Home   >   mailing lists

Re: Bypassing NULL elements in row_to_json function - Mailing list pgsql-general

From Michael Nolan
Subject Re: Bypassing NULL elements in row_to_json function
Date
Msg-id CAOzAqu+ZPZeQzf51=UjiNPVuEOy-enDthe0D4aYOSUALzONe8w@mail.gmail.com
Whole thread Raw
In response to Re: Bypassing NULL elements in row_to_json function  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Bypassing NULL elements in row_to_json function
List pgsql-general
Tree view
It looks like json_strip_nulls() may be what I need, I'm currently on 9.3, which doesn't have that function but may be in a position to upgrade to 9.5 this summer.   I think the apps that would be receiving the data can deal with any resulting 'holes' in the data set by just setting them to null.  
--
Mike Nolan


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: recover from this error
Next
From: "Feld, Michael (IMS)"
Date:
Subject: Re: pg_upgrade error regarding hstore operator