Hi Deepti,
As Peter pointed out (and I should have clarified), the server-side
features of each version should work regardless of client.
So the pg11 client will support all of the features of pg10 server (should
be fully compatible).
Best regards,
Jimmy
Jimmy Angelakos
Senior PostgreSQL
new release, but for the
above reasons you should try to match server and client versions.
Best regards
Jimmy
Jimmy Angelakos
Senior PostgreSQL Architect
2ndQuadrant - PostgreSQL Solutions for the Enterprise
https://www.2ndQuadrant.com/
On Fri, 13 Mar 2020 at 08:19, Deepti Sharma S
wrote
Hi Mario,
First off, as you will be aware, 9.2 is quite an old Postgres version
and is currently unsupported - for security reasons alone, you should
upgrade ASAP.
Regardless, this query should work for you:
SELECT xpath('/ProgramInformation/BasicDescription/CreditsList',
program_information.des
