Skip site navigation (1) Skip section navigation (2)

Re: 7.4 Wishlist

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hannu Krosing" <hannu(at)tm(dot)ee>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.4 Wishlist
Date: 2002-11-29 23:31:56
Message-ID: 096101c297ff$85bfcf30$6500a8c0@internal (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackers
Wow Hannu - your list puts mine to shame!

> "Application server support"
> ----------------------------
> * better XML integration
>
>   - XML(*) aggregate function returning XML representation of subquery
>
>   - XML input/output to/from tables
>
>   - XML searchable/indexable in fields)

I've had thoughts about XML too.  Since XML is hierachical, imagine being
able to index xml using contrib/ltree or something!

ie. We create a new 'xml' column type.

We create a new indexing scheme for it based on ltree & gist.

You index the xml column.

Then you can do sort of XPath queries:

SELECT * FROM requests WHERE xml_xpath('/request/owner/name', datafield) =
'Bob';

And it would be indexed.  Imaging being able to pull up all XML documents
that had certain properties, etc.

MS-SQL has a SELECT ... FOR XML clause, but we could always just create
function called xml_select() or something now that we can return recordsets.

Chris


In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2002-11-30 00:11:45
Subject: Re: Postgres 7.3 announcement on postgresql.org
Previous:From: Daniele OrlandiDate: 2002-11-29 23:06:46
Subject: Re: 7.4 Wishlist

pgsql-advocacy by date

Next:From: Philip WarnerDate: 2002-11-30 00:45:20
Subject: Re: 7.4 Wishlist
Previous:From: Ian BarwickDate: 2002-11-29 23:06:50
Subject: Oracle recognizes PostgreSQL as competitor?

pgsql-general by date

Next:From: Hubert depesz LubaczewskiDate: 2002-11-30 00:11:13
Subject: strange pg_stats behaviour?
Previous:From: Daniele OrlandiDate: 2002-11-29 23:06:46
Subject: Re: 7.4 Wishlist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group