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.kumar@xxxxxxxxxxxxxxxx Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general