René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : XMLTable function not supported","articleBody":"**PostgreSQL official documentation:**\n\nhttps://www.postgresql.org/docs/current/functions-xml.html#FUNCTIONS-XML-PROCESSING-XMLTABLE\n\n**Error trying to parse:**\n\n\u003cimg width=\"452\" height=\"89\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/0767f5d5-4cf7-4879-81cf-d424a0455d8b\" /\u003e\n\n\n**Steps to reproduce:**\n\n```-- Table to store XML data\nCREATE TABLE xmldata (\n    id SERIAL PRIMARY KEY,      -- optional, just for uniqueness\n    data XML NOT NULL           -- the XML column\n);\n\n-- Optional: Insert some dummy XML for testing\nINSERT INTO xmldata (data) VALUES\n(\n    '\u003cROWS\u003e\n        \u003cROW id=\"1\"\u003e\n            \u003cCOUNTRY_NAME\u003eCanada\u003c/COUNTRY_NAME\u003e\n            \u003cCOUNTRY_ID\u003eCA\u003c/COUNTRY_ID\u003e\n            \u003cSIZE unit=\"sq_km\"\u003e9984670\u003c/SIZE\u003e\n            \u003cPREMIER_NAME\u003eJustin Trudeau\u003c/PREMIER_NAME\u003e\n        \u003c/ROW\u003e\n        \u003cROW id=\"2\"\u003e\n            \u003cCOUNTRY_NAME\u003eFrance\u003c/COUNTRY_NAME\u003e\n            \u003cCOUNTRY_ID\u003eFR\u003c/COUNTRY_ID\u003e\n            \u003cSIZE unit=\"sq_mi\"\u003e248573\u003c/SIZE\u003e\n        \u003c/ROW\u003e\n    \u003c/ROWS\u003e'\n);\n\nSELECT xmltable.*\n  FROM xmldata,\n       XMLTABLE('//ROWS/ROW'\n                PASSING data\n                COLUMNS id int PATH '@id',\n                        ordinality FOR ORDINALITY,\n                        \"COUNTRY_NAME\" text,\n                        country_id text PATH 'COUNTRY_ID',\n                        size_sq_km float PATH 'SIZE[@unit = \"sq_km\"]',\n                        size_other text PATH\n                             'concat(SIZE[@unit!=\"sq_km\"], \" \", SIZE[@unit!=\"sq_km\"]/@unit)',\n                        premier_name text PATH 'PREMIER_NAME' DEFAULT 'not specified');```","author":{"url":"https://github.com/tomershay","@type":"Person","name":"tomershay"},"datePublished":"2025-10-12T17:54:36.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2326/JSqlParser/issues/2326"}