Erik Jones <erik(at)myemma(dot)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
In response to
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2008-04-24 22:43:11|
|Subject: Re: query question really cant give a summary here so read the body ;-)|
|Previous:||From: Erik Jones||Date: 2008-04-24 22:04:07|
|Subject: Re: Confused by result of pg_catalog.format_type() |