Warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: integer ~~ unknown at character 724 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /home/estacaodoradio/public_html/saude/dengue/library/db.php on line 160
ERROR: operator does not exist: integer ~~ unknown at character 724 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.ERRO NA QUERY =>>>> select N.codigo_noticia,N.titulo_noticia,to_char(N.datapublicacao_noticia,'DD/MM/YYYY') as datapublicacao_noticia,SUBSTRING(N.codigo_noticia,1,4) as projeto from noticia.noticia AS N LEFT JOIN noticia.noticia_responsavel AS NR ON N.codigo_noticia = NR.codigo_noticia LEFT JOIN noticia.destino_noticia AS D ON N.codigo_noticia = D.codigo_noticia LEFT JOIN uf ON D.codigo_uf = uf.codigo_uf LEFT JOIN projeto AS P ON SUBSTRING(N.codigo_noticia,1,4) = P.codigo_projeto where (N.datapublicacao_noticia >= '%1000-01-01%' and N.datapublicacao_noticia <= '%5000-01-01%' and N.datapublicacao_noticia <= NOW()) and N.titulo_noticia like '%%' and (N.codigo_noticia like '%PDEN%') OR (N.codigo_noticia like '%PDEP%') and (P.id_cliente like '%%') and P.id_tipoprojeto = 1 and NR.status_noticia_responsavel = 501 GROUP BY N.codigo_noticia, N.titulo_noticia, datapublicacao_noticia, projeto, N.datapublicacao_noticia order by N.datapublicacao_noticia desc
Result=
165