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