Re: [GENERAL] XML Support related questions

2008-05-27 Thread Peter Eisentraut
Brijesh Shrivastav wrote: > 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. Expression indexes on xpath are probably what you

Re: [GENERAL] XML Support related questions

2008-05-24 Thread Peter Eisentraut
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 d

Re: [GENERAL] XML Support related questions

2008-05-23 Thread Craig Ringer
Brijesh Shrivastav wrote: 1) Can xml column be constrained to be DOCUMENT or CONTENT type? XMLPARSE/XMLSERIALIZE functions allows to set XML option DOCUMENT or CONTENT type. Can we do the same when defining an xml column level? Maybe this could be done with a PL trigger ? Ideally you'd d

Re: [GENERAL] XML Support related questions

2008-05-23 Thread Stephane Bortzmeyer
On Thu, May 22, 2008 at 11:49:38AM -0700, Brijesh Shrivastav <[EMAIL PROTECTED]> wrote a message of 251 lines which said: > 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. It seems quite he