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 has similar functionality, but missing a some details and add lot of other functionality - it doesn't identify type of field. Personally - it is nothing what I like - but can be better than nothing. Pavel > > 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); > > 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
