Re: Please provide examples of rows from - Mailing list pgsql-docs

I wrote:
> You're right that the only suitable core function is going to be
> json[b]_to_recordset, but I don't see why you can't extend the
> existing example for that.  Something like

Meh, I was too hasty and pushed "send" with a broken example.  Better

=# select * from rows from (json_to_recordset('[{"a":1,"b":"foo"},{"a":"2","b":"bar"}]') as (a int, b text),
generate_series(1,3))as x(p,q,s); 
 p |  q  | s
---+-----+---
 1 | foo | 1
 2 | bar | 2
   |     | 3
(3 rows)

            regards, tom lane