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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster