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