| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Dan S <strd911(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How do I do this in plpgsql ? |
| Date: | 2011-03-19 22:02:26 |
| Message-ID: | 1C9D03B8-8CCF-4A9A-A078-E8E26851B0B9@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bosco Rama | 2011-03-19 22:26:22 | WAL shipping replication server re-sync |
| Previous Message | Vibhor Kumar | 2011-03-19 22:00:05 | Re: Insert value input syntax of an array of types without ARRAY/ROW nor casting? |