On Fri, Apr 04, 2008 at 04:32:36PM +0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote a message of 74 lines which said:
> INSERT INTO attribute2005 > VALUES(1,(23,'ee','ttt',('2005-01-01','2005-12-31'))); And why did you not post the error message? Because it is very clear: ERROR: malformed record literal: "ttt" DETAIL: Missing left parenthesis. Indeed, attributetype has no column for this 'ttt' value. The correct INSERT is: INSERT INTO attribute2005 VALUES(1,(23,'ee',('2005-01-01','2005-12-31'))); -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general