Request a Demo
Home   >   mailing lists

Re: How do I do this in plpgsql ? - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: How do I do this in plpgsql ?
Date
Msg-id 1C9D03B8-8CCF-4A9A-A078-E8E26851B0B9@enterprisedb.com
Whole thread Raw
In response to How do I do this in plpgsql ?  (Dan S <strd911@gmail.com>)
List pgsql-general
Tree view 
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@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: Insert value input syntax of an array of types without ARRAY/ROW nor casting?
Next
From: Bosco Rama
Date:
Subject: WAL shipping replication server re-sync