On Oct 23, 2012, at 6:03 PM, Merlin Moncure <[email protected]> wrote:
> On Tue, Oct 23, 2012 at 6:32 PM, <[email protected]> wrote: >> The following bug has been logged on the website: >> >> Bug reference: 7620 >> Logged by: Greg Hazel >> Email address: [email protected] >> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
