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
