Re: Broken Catalog? -- 7.4.2

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Broken Catalog? -- 7.4.2
Date: 2004-04-27 02:04:13
Message-ID: 20040427020413.GF2206@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-04-27 03:06:21 Re: FW: Timezone library
Previous Message Alvaro Herrera 2004-04-27 01:46:29 Re: Thread code not vpath-safe