Buenas Com a query abaixo
SELECT * FROM (SELECT A."code_id", A."descr", A."percent", A."meuxml", A."sr_recno", A."sr_deleted" FROM "test_tablext" A WHERE ( A."code_id" >= '00002' AND A."descr" >= 'Hello, SQL!' AND A."sr_recno" >= 2 ) ORDER BY A."code_id", A."descr", A."sr_recno" LIMIT 32 ) TMP1 UNION SELECT * FROM (SELECT A."code_id", A."descr", A."percent", A."meuxml", A."sr_recno", A."sr_deleted" FROM "test_tablext" A WHERE ( A."code_id" = '00002' AND A."descr" > 'Hello, SQL!' ) ORDER BY A."code_id", A."descr", A."sr_recno" LIMIT 32 ) TMP2 UNION SELECT * FROM (SELECT A."code_id", A."descr", A."percent", A."meuxml", A."sr_recno", A."sr_deleted" FROM "test_tablext" A WHERE ( A."code_id" > '00002' ) ORDER BY A."code_id", A."descr", A."sr_recno" LIMIT 32 ) TMP3 ORDER BY "code_id", "descr", "sr_recno" LIMIT 32 /* Skip FWD */ estou recebendo o seguinte mensagem ERROR: could not identify an ordering operator for type xml HINT: Use an explicit ordering operator or modify the query. ********** Erro ********** ERROR: could not identify an ordering operator for type xml SQL state: 42883 Dica: Use an explicit ordering operator or modify the query. como ajustar essa query? Atenciosamente Luiz _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
