r array as input parameter to postgresql 8.2
functions
Thanks a lot.
Regards,
Jyoti
-Original Message-
From: Pavel Stehule [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 11:27 AM
To: Jyoti Seth
Cc: [EMAIL PROTECTED]; pgsql-sql@postgresql.org
Subject: Re: [SQL] setof or arra
Thanks a lot.
Regards,
Jyoti
-Original Message-
From: Pavel Stehule [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 11:27 AM
To: Jyoti Seth
Cc: [EMAIL PROTECTED]; pgsql-sql@postgresql.org
Subject: Re: [SQL] setof or array as input parameter to postgresql 8.2
functions
2007/6/14
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 functio
:25 PM
To: Jyoti Seth
Cc: [EMAIL PROTECTED]; 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
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 <[EMAIL PROTECTED]>:
Hi,
I have to pass a set of values and
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
