Re: setof or array as input parameter to postgresql 8.2 functions
От | Jyoti Seth |
---|---|
Тема | Re: setof or array as input parameter to postgresql 8.2 functions |
Дата | |
Msg-id | 003201c7ae47$7ff80460$7fe80d20$@com обсуждение исходный текст |
Ответ на | Re: setof or array as input parameter to postgresql 8.2 functions ("Pavel Stehule" <pavel.stehule@gmail.com>) |
Ответы |
Re: setof or array as input parameter to postgresql 8.2 functions
|
Список | pgsql-sql |
Thanks for the solution. With this I am able to pass arrays and multidimensional arrays in postgresql functions. One of my problem is still left I want to pass set of values with different datatypes.For eg: I want to pass following values to the function: 1 ajay 1000.12 2 rita 2300.24 3 leena 1230.78 4 jaya 3432.45 As the values have different data types I have to create three different arrays. Is there any way with which I can pass this as a single setof values. Thanks, Jyoti -----Original Message----- From: Pavel Stehule [mailto:pavel.stehule@gmail.com] Sent: Wednesday, June 13, 2007 6:25 PM To: Jyoti Seth Cc: pgsql-general@postgresql.org; pgsql-sql@postgresql.org Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2 functions Hello maybe: create function foo(varchar[][]) returns void as $$ begin end$$ language plpgsql; postgres=# select foo(array[array[1,2], array[2,2]]::varchar[][]); foo ----- (1 row) Regards Pavel Stehule 2007/6/13, Jyoti Seth <jyotiseth2001@gmail.com>: > > > > > Hi, > > > > I have to pass a set of values and arrays in postgresql 8.2 functions. But I > am not getting any help on that. Please let me know if any one has idea. > > > > Thanks, > > Jyoti
В списке pgsql-sql по дате отправления: