title: What is the postgresql equivalent of RTRIM,XMLELEMENT and REPLACE in oracle?
body: <p>I know in oracle RTRIM,XMLELEMENT and REPLACE are used.But what is the postgresql equivalent of them?</p>
  <p>SELECT RTRM(XMLAGG (XMLELEMENT (E,REPLACE(                 )</p>
  <p>the above snippet is showing error in postgresql</p>