On 01/31/2014 08:57 AM, Merlin Moncure wrote:
On Fri, Jan 31, 2014 at 4:03 AM, Oleg Bartunov <obartu...@gmail.com> wrote:
Hmm,
neither me, nor Teodor have experience and knowledge with
populate_record() and moreover hstore here is virgin and we don't know
the right behaviour, so I think we better take it from jsonb, once
Andrew realize it. Andrew ?
Andrew Gierth wrote the current implementation of htsore
populate_record IIRC. Unfortunately the plan for jsonb was to borrow
hstore's (I don't think hstore can use the jsonb implementation
because you'd be taking away the ability to handle internally nested
structures it currently has). Of my two complaints upthread, the
second one, not being able to populate from and internally well formed
structure, is by far the more serious one I think.
Umm, I think at least one of us is seriously confused.
I am going to look at dealing with these issues in a way that can be
used by both - at least the populate_record case.
As far as populate_record goes, there is a bit of an impedance mismatch,
since json/hstore records are heterogenous and one-dimensional, whereas
sql arrays are homogeneous and multidimensional. Right now I am thinking
I will deal with arrays up to two dimensions, because I can do that
relatively simply, and after that throw in the towel. That will surely
deal with 99.9% of use cases. Of course this would be documented.
Anyway, Let me see what I can do.
If Andrew Gierth wants to have a look at fixing the hstore() side that
might help speed things up.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
