[GENERAL] Is there any way to recover updated values from the table(Need old value)

Hi All, Is there any way to get history value in postgres database because in one table unfortunately we have updated value but we need old data check ,Is there any way to find old (Same table has updated multiple times),We need oldest data, please inform me is there any way to recover data?

[GENERAL] How to change content of xml datatype

Hi All, I need to change content of xml ,Please any one suggest me how to do,the xml is below Grading_AutomatedPassOrFailFail/PassOrFailActivityScorebasedAutomatedSequence Value=0/Percentage25/PercentageValue34/ValueAutomatedSequence

[GENERAL] org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml

Hi All, I have added one column with xml type ,after adding I am getting following error. org.postgresql.util.PSQLException: ERROR: could not identify an equality operator for type xml If I have removed column following query works fine select * from (select * from KM_COURSE_MAST where ID in

[GENERAL] select Xpath is returning values with {}

Hi All, How to remove {} from output I am using below query select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast where id='10'))) from km_course_mast where id='10' The out is below {Grading_Automated /Grading_Automated} Thanks, Gajendra

[GENERAL] Please help me regarding the WITH RECURSIVE query

Hello All, I am migrating oracle queries to postgres queries *Oracle query is below* select * from (select * from KM_COURSE_MAST where ID in (select OBJ_ID from (select OBJ_ID,PERFORMER_TYPE,PERFORMER_ID from KM_REL_OBJ_PER_ACTION where OBJ_TYPE='COURSETYPE') where PERFORMER_TYPE='GROUP'