Re: how to insert values into complex type field

On Fri, Apr 04, 2008 at 04:32:36PM +0800,
windwxc(at)sina(dot)com <windwxc(at)sina(dot)com> 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')));