Mine

PHP LOG ERROR:

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



Running query on database via psql:

egd-felipe=# 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' -- Here can have more fields
                )
        )
;
 count
-------
    32
(1 row)



Show functions:

egd-felipe=# \df transupper
                       List of functions
 Schema |    Name    | Result data type  | Argument data types
--------+------------+-------------------+---------------------
 public | transupper | character varying | character varying
 public | transupper | text              | text
(2 rows)



Function sources

CREATE OR REPLACE FUNCTION transupper (text) RETURNS text language sql
AS $f$
select upper(translate($1,'ÁÉÍÓÚÃÕÑÇÊÂÔÄËÏÖÜáéíóúãõñçêâôäëïöü','AEIOUAONCEAOAEIOUaeiouaonceaoaeiou' ))
$f$;

CREATE OR REPLACE FUNCTION transupper (character varying) RETURNS character varying language sql
AS $f$
select upper(translate($1,'ÁÉÍÓÚÃÕÑÇÊÂÔÄËÏÖÜáéíóúãõñçêâôäëïöü','AEIOUAONCEAOAEIOUaeiouaonceaoaeiou' ))
$f$;