Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9DD629FB5C6 for ; Wed, 24 Jan 2007 07:20:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 18513-03 for ; Wed, 24 Jan 2007 07:20:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 03DC89FB5C1 for ; Wed, 24 Jan 2007 07:20:05 -0400 (AST) Received: (qmail invoked by alias); 24 Jan 2007 11:20:03 -0000 Received: from ip-90-186-233-61.web.vodafone.de (EHLO colt.pezone.net) [90.186.233.61] by mail.gmx.net (mp018) with SMTP; 24 Jan 2007 12:20:03 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: "Shoaib Mir" Subject: Re: Install XML on Postgres 8.1 Date: Wed, 24 Jan 2007 12:20:45 +0100 User-Agent: KMail/1.9.5 Cc: pgsql-admin@postgresql.org, "Rajesh Kumar Mallah" References: <45B4A1DA.1080404@yahoo.com.br> <200701240030.45045.peter_e@gmx.net> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200701241220.46204.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/223 X-Sequence-Number: 24379 Shoaib Mir wrote: > Do we have XML docs indexing mechanism in the todo's for 8.3? as this > is one of the problem I faced while moving the Oracle like XML > functionality to PostgreSQL using xml2 contrib. Indexing of data types is done in terms of operator classes (or maybe operator families in 8.3, not sure), but so far no one has proposed to define any operators whatsoever on the XML type, so I don't see where any indexing mechanism would come from at the moment. What does Oracle offer? -- Peter Eisentraut http://developer.postgresql.org/~petere/