Re: XML Support related questions

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(at)gmx(dot)net]
Sent: Saturday, May 24, 2008 4:32 AM
To: pgsql-general(at)postgresql(dot)org
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?