Current syntax: select COLUMN from ((select COLUMN from TABLE1) as TABLE2) Correct syntax: select COLUMN from (select COLUMN from TABLE1) as TABLE2
SqlSet SqlSelect::AsTable(const SqlId& tab) const { StringBuffer t; t << SqlCase(MSSQL|PGSQL, "")("(") //<---PGSQL added << "(" << text << ") as \t" << tab.ToString() << '\t' << SqlCase(MSSQL|PGSQL, "")(")"); //<---PGSQL added return SqlSet(String(t), SqlSet::HIGH); }
Report message to a moderator