Re: [HACKERS] add xml support function

2009-12-31 Thread fangfang liu
Sorry,guys, my mistakes, the keywords list should be sorted , and I just append xmlquery at the end of keyword list , that is why parser does not call makexmlexpr.Instead, the parser try to find a function to match xmlquery and faild. 2009/12/31 fangfang liu > thanks for Xquery info, I do not st

Re: [HACKERS] add xml support function

2009-12-31 Thread fangfang liu
thanks for Xquery info, I do not start to implenment the xmlquery() itself , maybe call xqilla lib or sth else in the future. I think xmltable is almost equal to xmlquery , except that it retuns talbeset insead of xml. I take xmlconcat as an example , add xmlquery whereever xmlconcat appers and no

Re: [HACKERS] add xml support function

2009-12-31 Thread fangfang liu
yes,whereever xmlconcat appears. 2009/12/31 Alvaro Herrera > fangfang liu escribió: > > > IS_XMLQUERY is added in primenodes.h > > > > but the parser can not find xmlquery, the makeXmlExpr is not called at > all. > > Did you add it to keywords.c etc? > > -- > Alvaro Herrera > http://www.CommandP

Re: [HACKERS] add xml support function

2009-12-31 Thread Alvaro Herrera
fangfang liu escribió: > IS_XMLQUERY is added in primenodes.h > > but the parser can not find xmlquery, the makeXmlExpr is not called at all. Did you add it to keywords.c etc? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Cus

Re: [HACKERS] add xml support function

2009-12-31 Thread Andrew Dunstan
fangfang liu wrote: you mean create and replace funtion xmlquery()? maybe you are right, but I still want to know why parser does not find xmlquery. We would have to see your code to know why it didn't do what you expect. What exactly are you intending that this function would do anywa

Re: [HACKERS] add xml support function

2009-12-31 Thread fangfang liu
you mean create and replace funtion xmlquery()? maybe you are right, but I still want to know why parser does not find xmlquery. thanks. 2009/12/31 Peter Eisentraut > On tor, 2009-12-31 at 19:22 +0800, fangfang liu wrote: > > Actually, I expect the function looks like xmlquery(xmlcontent,xquery

Re: [HACKERS] add xml support function

2009-12-31 Thread Peter Eisentraut
On tor, 2009-12-31 at 19:22 +0800, fangfang liu wrote: > Actually, I expect the function looks like xmlquery(xmlcontent,xquery) > and return the query result. You don't need to modify the parser for that at all. You can implement that in user-space as a user-defined function. -- Sent via pgs

Re: [HACKERS] add xml support function

2009-12-31 Thread fangfang liu
Actually, I expect the function looks like xmlquery(xmlcontent,xquery) and return the query result. So xmlconcat(xml1,xml2) become a good example to study. starting from gram.y, I try to make parser to call xmlquery,the following is the result of diff: diff gram.y c:\new_gram.y 449c449 < XM

Re: [HACKERS] add xml support function

2009-12-31 Thread Robert Haas
On Thu, Dec 31, 2009 at 3:33 AM, fangfang liu wrote: > Hi - Does anyone know how to add a xml support function into postgresql? > > I want to add a function named xmlquery into postgresql. > > I modify gram.y by adding xmlquery relatedcode wherever other xml support > functions appear. > but the p

[HACKERS] add xml support function

2009-12-31 Thread fangfang liu
Hi - Does anyone know how to add a xml support function into postgresql? I want to add a function named xmlquery into postgresql. I modify gram.y by adding xmlquery relatedcode wherever other xml support functions appear. but the parser can not find xmlquery, the makeXmlExpr is not called at all.