Re: question about information_schema

On Tue, 18 May 2004, Dave Cramer wrote:

> If I do create type testint8 as (i int8) and then select typbasetype
> from pg_type where typname='testint8' the value is 0?

You've created a complex type here, not a domain.  See typtype and 
typrelid for this case.

create domain testint8 as int8;  will do what you were expecting.

Kris Jurka