Broken Catalog? -- 7.4.2

On Mon, Apr 26, 2004 at 09:36:26PM -0400, Rod Taylor wrote:

The function format_type() fails only for interval when used on the
interval type

template1=# select format_type(oid, typlen) from pg_type;

select format_type(oid, typtypmod) from pg_type;
-- works

In fact, I believe this is the correct answer from timestamp types, for
example.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Having your biases confirmed independently is how scientific progress is
made, and hence made our great society what it is today" (Mary Gardiner)

On Mon, 2004-04-26 at 22:04, Alvaro Herrera wrote:

On Mon, Apr 26, 2004 at 09:36:26PM -0400, Rod Taylor wrote:

The function format_type() fails only for interval when used on the
interval type

template1=# select format_type(oid, typlen) from pg_type;

select format_type(oid, typtypmod) from pg_type;
-- works

In fact, I believe this is the correct answer from timestamp types, for
example.

Yes, your right. The only differences are with the timestamp types and
interval.

No matter -- I still have a bug in DBD::Pg ;)