[GENERAL] Confused by result of pg_catalog.format_type()

[Erik Jones]

Here's an example:

pagila=# select pg_catalog.format_type(prorettype, NULL) from pg_proc  
where proname='foo_ins_trig';

format_type
 -------------
"trigger"
(1 row)

Time: 3.212 ms
pagila=# SELECT 1
                 FROM pg_proc p
                 WHERE p.proname='foo_ins_trig'
                        AND pg_catalog.format_type(p.prorettype, NULL) = 
'trigger';

 ?column?
----------
(0 rows)

Time: 0.736 ms
pagila=#

What am I missing?

Erik Jones

DBA | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general