> The processing functions have been extended to provide populate_record() and populate_recordset() functions.The latter in particular could be useful in decomposing a piece of json representing an array of flat objects (a fairly common pattern) into a set of Postgres records in a single pass.

So this would allow an 'insert into ... select ... from 
<unpack-the-JSON>(...)'?

I had been wondering how to do such an insertion efficiently in the 
context of SPI, but it seems that there is no SPI_copy equiv that would 
allow a query parse and plan to be avoided.

Is this mechanism likely to be as fast as we can get at the moment in 
contexts where copy is not feasible?

In response to

• Re: json api WIP patch at 2013-01-07 22:15:47 from Andrew Dunstan

Responses

• Re: json api WIP patch at 2013-01-08 14:58:51 from Andrew Dunstan

pgsql-hackers by date

Next:	From: Takeshi Yamamuro	Date: 2013-01-08 09:04:24
	Subject: Re: Improve compression speeds in pg_lzcompress.c
Previous:	From: Pavan Deolasee	Date: 2013-01-08 06:17:17
	Subject: Re: Set visibility map bit after HOT prune