On Oct 23, 2012, at 6:03 PM, Merlin Moncure <mmonc...@gmail.com> wrote:
> On Tue, Oct 23, 2012 at 6:32 PM, <gha...@gmail.com> wrote:
>> The following bug has been logged on the website:
>>
>> Bug reference: 7620
>> Logged by: Greg Hazel
>> Email address: gha...@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.
>
> This is not really a bug because the feature is working as intended.
> Postgres arrays are homogonous so what you're asking really isn't
> possible. You can though use row_to_json to work around:
>
> select row_to_json(row('foo', 100, true));
That doesn't produce the same results.
Call it a feature request or a bug report, the postgres json support fails to
make the json I need.
-Greg
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
