[GENERAL] how to get UPDATEXML function in postgresql as it works in oracle

Hi, I am new to postgresql.We are migrating our application from oracle to postgresql.We are using postgresql version 9.2.All most everything we are migrated but I am unable to write a function for UPDATEXML which works same as in oracle.Please help me to resolve . Thanks & Regards, Saritha

[GENERAL] Unable to convert xpath value to date

Hi, I am getting an error while retrieving the values from xml and converting into date format when I execute this query select history from KM_REL_FF_USR_DATA whereUSERID in (53008) and SHARE_WORKING_GROUP =15683 output is " Enter what you want to achieve from this programme: " from th

Re: [GENERAL] Unable to convert xpath value to date

Thanks a lot,It worked for me. Thanks & Regards, Saritha On Thu, Oct 3, 2013 at 6:40 PM, David Johnston wrote: > saritha N wrote > > ERROR: invalid value "{0" for "dd" > > DETAIL: Value must be an integer. > > The leading "{"