时间戳

首页 > 解决方案 > groovy: postgres driver error: unnest:org.postgresql.jdbc.PgSQLXML@fb0c5b3

postgresql - groovy: postgres driver error: unnest:org.postgresql.jdbc.PgSQLXML@fb0c5b3

问题描述

A groovy script which executes beloved sql query outputs an error. However, same query works fine in pgAdmin4.

Postgres driver version: postgresql-42.2.2.jre7.jar

println con.firstRow("SELECT unnest(xpath('/html/body/span/text()'::text, body::xml)) FROM (SELECT REPLACE((SELECT body FROM email_service.message ORDER BY expiry DESC LIMIT 1), '<!DOCTYPE html>', '') AS body) pin")

What am I doing wrong?

标签： postgresqlgroovy

解决方案

[unnest:org.postgresql.jdbc.PgSQLXML@26b9569e] - is not an error

it's an xml-object that you have to download from server.

you can try 

println con.firstRow("SELECT unnest(...) as COL1 FROM ...").COL1.getString()

推荐阅读