Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-05 Thread Igor Neyman
> -Original Message- > From: utsav [mailto:utsav.ps...@tcs.com] > Sent: Monday, June 04, 2012 1:00 AM > To: pgsql-general@postgresql.org > Subject: Re: TYPE TABLE OF NUMBER > > No.. in this we have to define domain and than used it . Our > requirenment is like application pass the array

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-05 Thread utsav
Hi thomas .. Thanks for your help . I have done that thing . ] It is working fine -- View this message in context: http://postgresql.1045698.n5.nabble.com/TYPE-TABLE-OF-NUMBER-tp5710983p5711247.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-ge

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-04 Thread Thomas Kellerer
utsav, 04.06.2012 07:00: No.. in this we have to define domain and than used it . Our requirenment is like application pass the array of integer and that we have to use in PostgreSQL functions. You can pass an array directly. There is no need to define an "array type" in PostgreSQL -- Sen

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-04 Thread utsav
No.. in this we have to define domain and than used it . Our requirenment is like application pass the array of integer and that we have to use in PostgreSQL functions. -- View this message in context: http://postgresql.1045698.n5.nabble.com/TYPE-TABLE-OF-NUMBER-tp5710983p576.html Sent from t

Re: [GENERAL] TYPE TABLE OF NUMBER

2012-06-03 Thread Raghavendra
On Fri, Jun 1, 2012 at 9:18 PM, utsav 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