Erik Jones <erik@myemma.com> writes:
> Ah, pg_catalog.format_type(prorettype, null) = '"trigger"', thanks.
It's probably fair to ask what it is you want to accomplish here,
because comparing format_type's output to a constant seems awfully
fragile. Aside from the quotes (which I believe 8.3 won't emit in
this particular case) the output can vary depending on search_path
and perhaps other factors.
If you're trying to identify trigger functions I'd suggest
where prorettype = 'pg_catalog.trigger'::pg_catalog.regtype
as being the most bulletproof formulation, and probably faster too.
regards, tom lane