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