Message-ID: <554B84C0.1070007@gmail.com>
Date: Thu, 07 May 2015 16:29:04 +0100
From: Tim Dudgeon <tdudgeon.ml@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: generating json without nulls
References: <VisenaEmail.70.7125f92dc9db25c2.14d2ef26624@tc7-visena>
In-Reply-To: <VisenaEmail.70.7125f92dc9db25c2.14d2ef26624@tc7-visena>
Content-Type: multipart/alternative;
 boundary="------------020109050602040309020000"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

This is a multi-part message in MIME format.
--------------020109050602040309020000
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

That's not going to work. I want the row, I just don't want the values 
that are null.

Tim

On 07/05/2015 16:16, Andreas Joseph Krogh wrote:
>  På torsdag 07. mai 2015 kl. 12:56:42, skrev Tim Dudgeon 
> <tdudgeon.ml@gmail.com <mailto:tdudgeon.ml@gmail.com>>:
>
>     Hi All!
>     I'm using the postgres json functions to generate json for values in a
>     table.
>     Something like this:
>
>     SELECT row_to_json(a_table) FROM a_table
>
>     But my data has lots of null values and that results in json
>     attributes
>     like this:
>
>     "colname":null
>
>     I want to exclude those values from the json and only include non-null
>     values.
>     Any idea how to best go about this?
>
>     Tim
>
> WHERE colname IS NOT NULL ?
> -- 
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas@visena.com <mailto:andreas@visena.com>
> www.visena.com <https://www.visena.com>
> <https://www.visena.com>


--------------020109050602040309020000
Content-Type: multipart/related;
 boundary="------------040903060305030204080808"


--------------040903060305030204080808
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    That's not going to work. I want the row, I just don't want the
    values that are null.<br>
    <br>
    Tim<br>
    <br>
    <div class="moz-cite-prefix">On 07/05/2015 16:16, Andreas Joseph
      Krogh wrote:<br>
    </div>
    <blockquote
      cite="mid:VisenaEmail.70.7125f92dc9db25c2.14d2ef26624@tc7-visena"
      type="cite">
      <div> På torsdag 07. mai 2015 kl. 12:56:42, skrev Tim Dudgeon &lt;<a
          moz-do-not-send="true" href="mailto:tdudgeon.ml@gmail.com">tdudgeon.ml@gmail.com</a>&gt;:</div>
      <blockquote style="border-left: 1px solid rgb(204, 204, 204);
        margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
        <div style="display:inline; font-family: monospace; font-size:
          12px;">Hi All!<br>
          I'm using the postgres json functions to generate json for
          values in a<br>
          table.<br>
          Something like this:<br>
          <br>
          SELECT row_to_json(a_table) FROM a_table<br>
          <br>
          But my data has lots of null values and that results in json
          attributes<br>
          like this:<br>
          <br>
          "colname":null<br>
          <br>
          I want to exclude those values from the json and only include
          non-null<br>
          values.<br>
          Any idea how to best go about this?<br>
          <br>
          Tim</div>
      </blockquote>
      <div> </div>
      <div>WHERE colname IS NOT NULL ?</div>
      <div> </div>
      <div class="origo-email-signature">
        <div>--
          <div><span style="font-family:arial,helvetica,sans-serif;"><strong>Andreas
                Joseph Krogh</strong></span></div>
          <div><span style="font-family:arial,helvetica,sans-serif;">CTO
              / Partner</span> - Visena AS</div>
          <div><span style="font-family:arial,helvetica,sans-serif;">Mobile:
              +47 909 56 963</span></div>
          <div><a moz-do-not-send="true"
              href="mailto:andreas@visena.com">andreas@visena.com</a></div>
          <div><a moz-do-not-send="true" href="https://www.visena.com">www.visena.com</a></div>
          <div style="padding-top: 5px"><a moz-do-not-send="true"
              href="https://www.visena.com"><img alt=""
                src="cid:part4.03020903.06040602@gmail.com"></a></div>
        </div>
      </div>
      <div> </div>
    </blockquote>
    <br>
  </body>
</html>

--------------040903060305030204080808
Content-Type: image/png
Content-Transfer-Encoding: base64
Content-ID: <part4.03020903.06040602@gmail.com>

iVBORw0KGgoAAAANSUhEUgAAAIUAAAAYCAYAAADUIj6hAAAABHNCSVQICAgIfAhkiAAABzBJ
REFUaEPtmNFxHDcMhmVP3i1VECpvnjzkVIHWFfhcgVcVRKrAUgWRK/C6Al8H3lTgy0PGbzFd
Qc4VJP/HADs43q6kROeJNbOYgQACIAgCWJKng4MZ5gxUGXh0U0b+SIuF9G+EWXj2Q15vbrE/
NPtk9uub7Gfdt5mBx1NhqSEo8HshjbEUtlO2yIM9tsx5dZP9rPt2MzDZFAqZE4LGcFjdsg3s
aQaHt7fY70X949OnaS+OZidDBkavD33157L4xaw2os+Mp/DAC10l2XhOCeStj0W5ajrJL8Wf
Ci80Xgf9vVlrhg9yRONe/f7xI2vNsIcM7JwU9o6oGyJrLT8JOA1aX9sKP4wl94bAniukEbo/
n7YPmuTETzIab4Y9ZWCrKexd8M58lxPCvvD6aihfvexbEQoPYO8NQRO0JnddGO6FJYaVsBde
7cXj7KRk4LsqDxQzCYeGsJNgaXZe+JXkyGgWINq3Gp+bHNILz+wEYs5qH1eJrouNrpDXtk4O
6x1IvtD40GWyJYYdkF0jIbYZlN16xygIgl9smbMDsmFdfAKb23xGB8H/mv3tOJfArs1kukk7
9DEPdQ5u0g1vCvvqKXIW8mZYW+F3Tg4r8HvZkQCCLydK8EFMQCe5N8RgL9mRG0SqQFuNvdE6
beSs0qPDBuCdg0+gvClso8SbTO4ki7mQzQqBrcMHQPwReg2wW8umEe/+L8T/LEzBGF9nXjzZ
46s+ITHvhegW8LL39xm6App7KYL/GE+vcYnFbJiP/0aYhdiCnRC7jaj7eiK2ETInC5PRF6LY
kSN0+HabF75WuT6syCyI0YkVGGMvUC33AmfZTDUEj8u6IVhuEhRUJ2U2g6UlugyNb03Hl9ob
HwlxJbcRzcYjO4QPjVfGFTQav4vrmp7cpMp2qbHnBxWJbisbho2QXI6C1sIHDUFhH4Hij4Ub
Iev66eANeiwbkA+LBsO36zAHzoXU7AhbqLAXEiOYTXcSdO8VS9L4wN8UBIYhBd6oSUgYMijO
kecRuTdQa/YiBXhbXFcnCnI2SrfeBG9NydrLYMhGHa5qB9pQIxlzAE6OkjzxJO5afGe6kmhB
icWKQNKuTZ5EW+MjQY8v/9rQ0bhJSJyNGUe/JH1t8h1iMbdSPAvxHYin6YmN9YBXQmTYZZNh
14vHhhhal5vtcIrJjmvszPRJdExH3MWHvykoBEc9CoCGWJisOLOGoCORs1FvIMbYA8z3kwM5
9oemy6LlWrLxFLmWgiQAfEGd8S+NssbK+EhyGLxUkhhiy717waBqHOJYSEacwBejkFNhjJNj
v/gANOdQxPfciP/JVBCK2cOIcg3RRJ+CPrLPNVhhN6F38VKMF3XLlIJrjU5C8gMFxvKDvOcP
c4rVNjCn7KM0BV+161V8viSCuJZ8SITGJGEh7IUUlxOFMYUH1kJOCN4Wh+I5pqCuK01k40kS
NtnKiKIlUfxAgW5sU5JlS05rtt5YFJF1SWoqHv6BRgQcA4/bdb9WRjmMk3jyUMAbIoyJq9e4
cVmgzKt9j5gNJ/aYDhk+hhjExwaPcz5PObA5Zd9bvz5UzCTZuZDidu5AchpiKSwPR+TV1bCW
qBQ9nCjJ5neivC82Nr4LeS2j1gw5LUqwBuhGQQU5UwHeSslXkwIynz2U2A2yKDgG7OffwLA3
TpGRpk0Tzpj3ZEJXi/GRa6GN0e0NtppChePdcAz1FTS+FN8Kpxoiykk+J8fC5tenjbu9kSqp
HLu9jBrhUuhNwVGbpyZrzrl0HPVD8SXj5EOOD/eDC64VjvYBZLuUbIVAfBN1t/C/SU+cAGtd
Go+fVnzycUX5wmn6eCKPmWYJG2E/ppTsuRCbvUD9fwquksG5GqLVKhzDQ3GrEyLKSXhsiK3T
5j9EyxffCFOYi2wUlPyFFDQAhehESDjQGoX0ho0oj8RPou6TxHJdcT0NTcWkO0AnG7+uXsnH
qcas/72wvWF+mSf7N/Watp9kTXoluzeS0fB99CcZ/hvhSZTfh99pispZOXL9KrGrARkNUMu9
ITbScZWs7xOYNt9pwxSZtYDsX/GE3xTkrXgwAsXmfud08FiTeC+m2/o7ppo+PTS/NBK5ARpD
G5YHr++DpmVfreYdiX8mnp+DzPEG9WbqJON0JBenZofssxBA1gj5NXGvfJu/Qh7HwQh/VDUE
yUxCit5hH94QfKkEdu+GwK8BX0hvCF+D67xhjmXQCXMwJCZ+olK0A1EKRCE4snsh42w8Mv/Z
hxw9iD7Cjo7CyQC/KyF6oBfShL4PYgG+CHsYKyZxvxZSZBAgjhIzYDz+AbfD37GtbaoSKzgG
t+lKfI/GZtay6vG4VXTpPsh+IcQhOk9I7WYeP5AM3HZ9+DaSGIp9HIuuhuC4pCGGx+YD2fcc
5tfIAA0h/Et4/jX8zz4fWAasIf4UbR9Y6HO4d8jAnd4U0Y8ageuCB+c+H5R3CHU2mTMwZ+B/
y8DfSMBLLOYXVuEAAAAASUVORK5CYII=
--------------040903060305030204080808--

--------------020109050602040309020000--