Postgres Pro
Downloads
Home   >   mailing lists

BUG #7620: array_to_json doesn't support heterogeneous arrays - Mailing list pgsql-bugs

From ghazel@gmail.com
Subject BUG #7620: array_to_json doesn't support heterogeneous arrays
Date
Msg-id E1TQnxe-0002WI-DP@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7620: array_to_json doesn't support heterogeneous arrays  (Merlin Moncure <mmoncure@gmail.com>)
Re: BUG #7620: array_to_json doesn't support heterogeneous arrays  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      7620
Logged by:          Greg Hazel
Email address:      ghazel@gmail.com
PostgreSQL version: 9.2.1
Operating system:   Amazon Linux
Description:        =


array_to_json(ARRAY['foo', 100, true]) complains because arrays can't have
mixed types, but json arrays can.

So, it's not possible to form a heterogeneous json array, when this is often
desired.

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: Posrgresql for Suse linux 64-bit version on OS/390
Next
From: Merlin Moncure
Date:
Subject: Re: BUG #7620: array_to_json doesn't support heterogeneous arrays