On Mar 19, 2011, at 12:50 AM, Dan S wrote:
>
> For example if I have a type sample%TYPE
> How can I declare a variable that is an array of sample%TYPE
> I can't get it to work, is there a way to do it ?
Nope, there is no way. However, you can create a userdefined type and can also use array of that
http://www.postgresql.org/docs/8.4/static/sql-createtype.html
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com