Re: [HACKERS] Broken Catalog? -- 7.4.2

2004-04-27 Thread Rod Taylor 
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 ;)


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

[HACKERS] Broken Catalog? -- 7.4.2

2004-04-26 Thread Rod Taylor 
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



---(end of broadcast)---
TIP 8: explain analyze is your friend

Re: [HACKERS] Broken Catalog? -- 7.4.2

2004-04-26 Thread Alvaro Herrera 
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)

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])