Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199401281808.KAA14066@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Fri, 28 Jan 1994 10:08:38 -0800
From: Sunita Sarawagi <sunita@postgres.Berkeley.EDU>
Message-Id: <199401281808.KAA29455@utopia.CS.Berkeley.EDU>
To: SRIRAMK@charlie.usd.edu, postgres@postgres.Berkeley.EDU
Subject: Re:  Resending my query and problem with correction
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Fri, 28 Jan 94 10:08:45 -0800
Resent-XMts: smtp

> I created a user defined type as follows :
> 
>    define type lines (internallength = variable, 
>                      input          = array_in , 
> 		     output         = array_out, 
> 		     element        = text);
> 
> I then used this user defined type for class creation :
> 
>    create BLOCK (id = int4, content = lines);
> 
> Now when I try to append to class BLOCK as in :
> 
>    append BLOCK (id = 5 , content = "This is a test");
> 
> I get the  following error message
> 
>  array_in: malformed array constant

All array constants need to be enclosed within curly braces. So the
right syntax for your input will be ..

append BLOCK (id = 5 , content = "{"This is a test"}");

For storing multiple lines you need to seperate the elements by a comma.
Example: 
	append BLOCK (content = "{"This is a test", "This is another test"}")


Sunita Sarawagi.