Skip site navigation (1) Skip section navigation (2)

row_to_json() Bug

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: pgsql-hackers Hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: row_to_json() Bug
Date: 2012-02-24 01:35:09
Message-ID: 1B70BD5A-B70A-471B-8AF5-371FFE2647D3@justatheory.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Looks like row_to_json() thinks 0s are nulls:

    postgres=# select row(0);
     row 
    -----
     (0)
    (1 row)

    postgres=# SELECT row_to_json(row(0));
     row_to_json 
    -------------
     {"f1":null}
    (1 row)

Best,

David


Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2012-02-24 02:09:21
Subject: Re: row_to_json() Bug
Previous:From: Harold GiménezDate: 2012-02-24 00:38:13
Subject: Reviewing patch "URI connection string support for libpq"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group