2007/6/14, Jyoti Seth <[EMAIL PROTECTED]>:
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.
You have to wait for 8.3 where arrays on composite types are
supported. Currently in one our application we use array of arrays
where different types are too, and we cast it to text.
Regards
Pavel
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
