Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
Thank you! Since you brought up the subject, will this //[EMAIL PROTECTED] = "02"] be slower than /mydocument/body/chapter/contents/[EMAIL PROTECTED] >> = "02"] when handling a big document? I mean from the query time point of view ... Csaba Nagy wrote: > Marian, > >> 1. >> SELECT >>

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
You are right; I had a typo : contents is content Thanks for replying ... Guy Rouillier wrote: > Marian POPESCU wrote: >> There is also a weird thing: >> >> >> SELECT >> xpath_nodeset(rawdata, >> '/mydocument/body/chapter/contents/para

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
ce I make a fool of myself ;) Thank you for the replies and sorry for wasting your time! Csaba Nagy wrote: > Marian, > > On Mon, 2006-08-07 at 17:47, Marian POPESCU wrote: > >> SELECT >> xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph') >

Re: [GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
Thanks for replying. It was a typo ... Also id fom example should be objid ... Anyway, without the typo, the result set is empty. There is also a weird thing: SELECT xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph') FROM xmldocuments will output xpath_nodeset

[GENERAL] XPath question - big trouble

2006-08-07 Thread Marian POPESCU
Hello everyone, First of all, thank you for integrating XPath in Postgresql. But, as you will see, this is a desperate cry for help: 1. the actual context: Postgresql 8.1.4, Fedora Core 5 DATABASE = CREATE TABLE xmldocuments ( id int8 NOT NULL, rawdata text, title varchar(255),

Re: [GENERAL] PostgreSQL Developer Network

2005-06-03 Thread Marian POPESCU
Gevik babakhani wrote: > Dear People, > > > > After a long time of various timeouts, I managed to get back on track > developing the long promised PQDN website. As some of you might know. I > was working on a project called the PostgreSQL Developer Network. > > > > The websites (which is a

[GENERAL] "Invalid multibyte character for locale" still there

2005-01-31 Thread Marian POPESCU
Hi, I want to report a bug on PG 8.0 (linux : Fedora Core 3) A LIKE '%langage C%' in the WHERE clause of my SELECT statement gives "invalid multibyte character for locale" error. I thought the bug https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=113231 was fixed and the patch was incorporate

Re: [GENERAL] PostgreSQL 8.0.0 Beta 3 Uploaded

2004-10-01 Thread Marian POPESCU
Are there also SRPMs? I'm interested on Fedora Core 2 ones. I have rebuilt from SRPMs the Beta2 and it works OK - I only had to change the init script - the version provided was 7.4. Marian ---(end of broadcast)--- TIP 3: if posting/reading throug