Re: TYPE TABLE OF NUMBER

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

On Fri, Jun 1, 2012 at 9:18 PM, utsav <utsav.pshah@xxxxxxx> 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/