08/05/2007-15:39:38 # 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' ) )

---