Re: Re: Re: Storing XML in PostgreSQL

Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

> I've packaged up what I've done so far and you can find it at
> http://www.cabbage.uklinux.net/pgxml.tar.gz
> 
> The TODO file included indicates what still remains to be done (a lot!).
> 
> In particular, it would be good to implement more of the XPath grammar.
> However, once we get into the realm of more complex paths there becomes a
> question about optimisation of XPath selection. If the documents are
> pre-parsed, then XPath query elements can be rewritten as SQL queries and
> you get the optimisation of the planner on your side.
> 
> I'd like to stick with the current solution if possible, because I think
> it delivers a very simple interface to the user and is (code-wise) also
> very straightforward. Maybe less efficient queries are a penalty worth paying?
> 
> Any thoughts?
> 
> Regards
> 
> John
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026