Confused by result of pg_catalog.format_type()

From: Erik Jones <erik(at)myemma(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Confused by result of pg_catalog.format_type()
Date: 2008-04-24 21:55:05
Message-ID: B89980A1-9435-44F0-AC18-11022966BB27@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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®
erik(at)myemma(dot)com
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-24 21:58:15 Re: Confused by result of pg_catalog.format_type()
Previous Message Andreas 'ads' Scherbaum 2008-04-24 21:43:26 Re: How to modify ENUM datatypes?