All pastes #477566 Raw Edit

Stuff

public text v1 · immutable
·published 2007-05-08 18:42 UTC
rendered paste body
<FONT COLOR='0000FF'>08/05/2007-15:39:38</FONT><FONT COLOR='FF0000'> # Query: PostgresERROR:  function transupper(character varying) does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts.::query # /export/httpd/dev-cportal/priscila/institucional/classes/packDataAccess/classPostgres.cd # 202 #  # select count(distinct news.newcod) as count from
                                        PB_NEWS news  inner join PB_NEWS_CATEGORY newscat on
                                                news.newcod = newscat.newcod and newscat.cattab = 21 where news.newsta ='O' and
                                        news.newflg=1 and ( ( transupper(news.newtit) ~ 'A' ) )</FONT><HR>