"Andrew Thorley" <[EMAIL PROTECTED]> writes: > CREATE TYPE qwerty_UDT AS (abc INT); > CREATE TABLE t (col1 qwerty_UDT); > INSERT INTO t (col1) VALUES (qwerty_UDT(123)); > ERROR: function qwerty_udt(integer) does not exist
Just say INSERT INTO t (col1) VALUES (ROW(123)); Note this will not work at all on pre-8.0 Postgres. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]