Relative Content

Tag Archive for sqldatabasepostgresql-9.6postgresql-16

Postgres Version 9.6 skips syntax error while 16.3 doesn’t

UPDATE Image SET objectid= objectid,PatientID=$$138393$$,StudyID=$$143601$$,SeriesID=$$161058$$,ImageUID=$$1.2.840.113619.2.275.57473.11731861.9941.1464792356.86$$,OrderInSeries=$$2$$,FileName=$$20160604143601Org.img.20240526162016828.957946.dcm$$,PubFileName=$$20160604143601Pub.img.20240526162016828.957946.dcm$$,ThumbFileName=$$20160604143601Thumb.img.20240526162016828.957946.BMP$$,isanonymized=0where ObjectID=’957946′ THIS Query doesn’t run on postgres version 16.3 and runs on version 9.6 for example Space between isanonymized and where: There should be a space between isanonymized=0 and where. how to make 16.3 skip this type of errors like 9.6 i want postgres 16.3 to run the query just […]