Postgres Pro
Downloads
Home   >   mailing lists

Re: TYPE TABLE OF NUMBER - Mailing list pgsql-general

From Raghavendra
Subject Re: TYPE TABLE OF NUMBER
Date
Msg-id CA+h6AhieJg5jVQ97n=4kcH5-iDXzf2=qs3UWLSOfrHoRJbFZPQ@mail.gmail.com
Whole thread Raw
In response to TYPE TABLE OF NUMBER  (utsav <utsav.pshah@tcs.com>)
Responses Re: TYPE TABLE OF NUMBER  (utsav <utsav.pshah@tcs.com>)
List pgsql-general
Tree view
On Fri, Jun 1, 2012 at 9:18 PM, utsav <utsav.pshah@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 ?

pgsql-general by date:

Previous
From: Alexander Reichstadt
Date:
Subject: Re: [postgres no lnger launches
Next
From: Robert Gravsjö
Date:
Subject: Re: Question: How do you manage version control?