Thread: Broken Catalog? -- 7.4.2

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

template1=# select format_type(oid, typlen) from pg_type;
ERROR:  invalid INTERVAL typmod: 0xc
template1=# select format_type(oid, typlen) from pg_type where typname
!= 'interval';
-- Many results

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 ;)