On 3/19/09 2:40 PM, Dimitri Fontaine wrote:
Hi,
Le 19 mars 09 à 21:23, Josh Berkus a écrit :
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.
The problem is more how to have the parser know which data type to
target, because you want to avoid having to create a new cast per each
composite type you want to target.
Or you could just have it fail if there's no cast between TEXT and the
target type.
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
