Hey David, 2010/11/9 David E. Wheeler <da...@kineticode.com>
> On Nov 9, 2010, at 1:38 AM, Dmitriy Igrishin wrote: > > > * text[] = record_to_array(record) > > * table(id, key, datatype, value) = record_to_table(record) > > * text = record_get_field(record, text) > > * record = record_set_field(record, text, anyelement) > > > > ?? > > I personally like it. But I propose to add as well: > > integer := record_nkeys(); > > text := record_get_field(record, integer); > > You realize you can pretty much do all this with hstore, right? > > hstore hash := hstore(record); > ary text[] := hstore_to_matrix(hash); > select * from each(hash); -- TABLE > text foo := hash -> somekey; > hash := hash || '"key","value"'::hstore; > record := populate_record(record, hash); > > Yep, but hstore is an additional module. Although, its not a problem. > Best, > > David > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- // Dmitriy.