I have query with implicit conversion (::bigint) in PostgresSQL:
SELECT te.ci_etapa, te.ds_etapa FROM (academico.tb_etapa te JOIN academico.tb_item ti ON ((te.ci_etapa = ti.cd_etapa))) WHERE (((((((((ti.fl_tipo_seriacao)::text = 'RG'::text) OR ((ti.fl_tipo_seriacao)::text = 'MS'::text)) OR ((ti.fl_tipo_seriacao)::text = 'ME'::text)) AND (te.ci_etapa <> ALL (ARRAY[(136)::bigint, (129)::bigint, (126)::bigint, (128)::bigint, (127)::bigint]))) AND ((ti.ds_itemativo = 'S'::bpchar) OR (te.ci_etapa = ANY (ARRAY[(121)::bigint, (122)::bigint, (123)::bigint, (155)::bigint, (156)::bigint])))) AND (ti.cd_nivel = ANY (ARRAY[26, 2]))) AND (ti.cd_modalidade = ANY (ARRAY[1, 36, 20]))) AND (ti.cd_prefeitura = 0)) GROUP BY te.ci_etapa, te.ds_etapa ORDER BY te.ci_etapa
::bigint -> Native PostgresSQL
Error: net.sf.jsqlparser.parser.TokenMgrError: Lexical error at line 1, column 156. Encountered: ":" (58), after : ""
Can someone help me????
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have query with implicit conversion (::bigint) in PostgresSQL:
SELECT te.ci_etapa, te.ds_etapa FROM (academico.tb_etapa te JOIN academico.tb_item ti ON ((te.ci_etapa = ti.cd_etapa))) WHERE (((((((((ti.fl_tipo_seriacao)::text = 'RG'::text) OR ((ti.fl_tipo_seriacao)::text = 'MS'::text)) OR ((ti.fl_tipo_seriacao)::text = 'ME'::text)) AND (te.ci_etapa <> ALL (ARRAY[(136)::bigint, (129)::bigint, (126)::bigint, (128)::bigint, (127)::bigint]))) AND ((ti.ds_itemativo = 'S'::bpchar) OR (te.ci_etapa = ANY (ARRAY[(121)::bigint, (122)::bigint, (123)::bigint, (155)::bigint, (156)::bigint])))) AND (ti.cd_nivel = ANY (ARRAY[26, 2]))) AND (ti.cd_modalidade = ANY (ARRAY[1, 36, 20]))) AND (ti.cd_prefeitura = 0)) GROUP BY te.ci_etapa, te.ds_etapa ORDER BY te.ci_etapa
::bigint -> Native PostgresSQL
Error: net.sf.jsqlparser.parser.TokenMgrError: Lexical error at line 1, column 156. Encountered: ":" (58), after : ""
Can someone help me????