Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-28 Thread Craig Ringer
On 10/24/2012 11:46 PM, Greg Hazel wrote: > Another option that just occurred to me is a new function (say, to_json) that > converts the parameter to its json representation, with type json. > > Then this would be possible: > > select array_to_json(ARRAY[to_json('foo'), to_json(100), to_json(true)

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Greg Hazel
On Oct 24, 2012, at 12:21 AM, Craig Ringer wrote: > On 10/24/2012 07:32 AM, 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 >> Opera

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Greg Hazel
On Oct 23, 2012, at 6:17 PM, Merlin Moncure wrote: > On Tue, Oct 23, 2012 at 8:05 PM, Greg Hazel wrote: >> On Oct 23, 2012, at 6:03 PM, Merlin Moncure wrote: >> >>> On Tue, Oct 23, 2012 at 6:32 PM, wrote: The following bug has been logged on the website: Bug reference: 7

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Greg Hazel
On Oct 24, 2012, at 12:21 AM, Craig Ringer wrote: > On 10/24/2012 07:32 AM, 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 >> Operat

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Greg Hazel
On Oct 23, 2012, at 6:03 PM, Merlin Moncure wrote: > On Tue, Oct 23, 2012 at 6:32 PM, 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 s

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Merlin Moncure
On Wed, Oct 24, 2012 at 2:21 AM, Craig Ringer wrote: > On 10/24/2012 07:32 AM, 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 >> Opera

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-24 Thread Craig Ringer
On 10/24/2012 07:32 AM, 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_

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-23 Thread Merlin Moncure
On Tue, Oct 23, 2012 at 8:05 PM, Greg Hazel wrote: > On Oct 23, 2012, at 6:03 PM, Merlin Moncure wrote: > >> On Tue, Oct 23, 2012 at 6:32 PM, wrote: >>> The following bug has been logged on the website: >>> >>> Bug reference: 7620 >>> Logged by: Greg Hazel >>> Email address:

Re: [BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

2012-10-23 Thread Merlin Moncure
On Tue, Oct 23, 2012 at 6:32 PM, 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['f