Re: parsing xml with PG 9.2.4

2020-02-17 Thread Jimmy Angelakos
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

parsing xml with PG 9.2.4

2020-02-17 Thread Mario Vlahovic
Hello Developers, I hope you can help me. I'm having troubles parsing some data from my psql table, which I need for further manipulation. So my query: select program_information.description FROM program_information WHERE id = 8768787; GIves me: Zla smrt Pet prijateljev, starih neka