On 3/19/09 1:23 PM, Josh Berkus wrote:
Andrew,
One request I've had is to construct a record (of some supplied
composite type) from an hstore.
I'm not sure if this is even possible; I'm certainly not seeing a way
to implement it. Am I missing something?
Well, presumably you'd try to match hstore tags against the "columns" of
the composite type, and where a tag didn't exist, return NULL,and where
one isn't in the composite type, ignore it. All data would be TEXT.
Oh, and in features I'd want, mostly an UNROLL for hstore ... that is,
rather than a RECORD, a set of exploded rows.
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
