[问题记录.PostgreSQL]pg中执行包含union的sql报： SQL 错误 [42601]: 错误: 语法错误 在 “union“ 或附近的

【问题描述】

执行SQL（这个sql做了简化）

select col1 from (select 'a' as col1) tb order by col1
union 
select col1 from (select 'b' as col1) tb order by col1

报错：

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [42601]: 错误: 语法错误 在 "union" 或附近的   Position: xxx     at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)     at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:513)     at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:444)     at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171)     at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:431)     at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:816)     at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3501)     at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:118)     at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:171)     at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:116)     at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4821)     at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)     at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

【解决办法】

更改sql写法，用括号()把sql子句括起来：

(select col1 from (select 'a' as col1) tb order by col1) 
union 
select col1 from (select 'b' as col1) tb order by col1