On 22/12/11 10:44, Tom Lane wrote: > "Johann 'Myrkraverk' Oskarsson" <joh...@2ndquadrant.com> writes: > > I mean to create a typed hstore, called tstore for now. > > Um ... what is the point of this, exactly? From what I've seen, most > applications for hstore are pretty happy with the fact that hstore is > only weakly typed, and if an entry *is* an integer, or a float, or > whatever else, it's not hard to cast to and from text as needed.
More over it is also easy with the current hstore to add constraints like this: "contracts_is_an_integer" CHECK ((tags -> 'contracts'::text) ~ '^[0-9]+$'::text) to ensure that it actually is. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers