I guess you can also get this before writing code from select typbyval from pg_type where typname='mytype'
...thanks again. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq