Thanks Peter for your responses. I will try constraint for # 1 but I think it probably will still make sense to include that as part of XML column definition. I assume the default xml data type is of CONTENT type. For #4 I was looking to be able to index some or all of the tags in the xml document. Most of our applications query very few tags in a Xml document and a smaller index on few tags will help with query performance. Any guess on timeframe for #2, #3 and #4? Thanks, Brijesh -----Original Message----- From: Peter Eisentraut [mailto:peter_e@xxxxxxx] Sent: Saturday, May 24, 2008 4:32 AM To: pgsql-general@xxxxxxxxxxxxxx Cc: Brijesh Shrivastav Subject: Re: [GENERAL] XML Support related questions Am Donnerstag, 22. Mai 2008 schrieb Brijesh Shrivastav: > 1) Can xml column be constrained to be DOCUMENT or CONTENT type? Using a check constraint that does IS [NOT] DOCUMENT on the value. > 2) Is there plan in near future to support XML schema validation > i.e to ensure inserted xml document conforms to a preregistered set of > XML schemas. Plans yes, but I don't think anyone is working on it at the moment. > 3) Support for XQuery - I know it is asking for too much but when > do you see it happening in the future. See #2. > 4) Support for xml indexes - Is it something that is being worked > upon for next release? See #3. ;-) Of course this question is a bit underspecified, because indexes depend on some operators, and XML does not have any operators at the moment, so what do you want to index?
