On Fri, Jun 1, 2012 at 9:18 PM, utsav <utsav(dot)pshah(at)tcs(dot)com> wrote:
> we are doing mgration activity form oracle to postgresql 9.1
>
> How to convert this type :
>
> ORACLE :
>
> CREATE OR REPLACE TYPE "NUMBER_ARRAY" IS TABLE OF NUMBER
>
> please let me know how we can achive this in postgresql
>
>
> My understanding
>
> POSTGRESQL :
>
> CREATE TYPE "NUMBER_ARRAY" AS (arr int);
>
> Appreciate any help !
>
>
Does this helps ?
http://www.postgresql.org/docs/9.1/static/sql-createdomain.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/