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
On Fri, 4 Apr 2008 [EMAIL PROTECTED] wrote:
> hi all, i want to know how to insert values into the field which is a complex
> type. In fact it is a complex type which also include a complex type. The
> following is its definition:
> create TYPE lifetime as( strattime date, endtime date);
> crea
hi all, i want to know how to insert values into the field which is a complex
type. In fact it is a complex type which also include a complex type. The
following is its definition:
create TYPE lifetime as( strattime date, endtime date);
create TYPE attributetype as( ID numeric, address character(
