Postgres Pro
Downloads
Home   >   mailing lists

Re: setof or array as input parameter to postgresql 8.2 functions - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: setof or array as input parameter to postgresql 8.2 functions
Date
Msg-id 162867790706130555r5a1ba9cbq1c3e2cb0f1adbda7@mail.gmail.com
Whole thread Raw
In response to setof or array as input parameter to postgresql 8.2 functions  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
Responses Re: setof or array as input parameter to postgresql 8.2 functions  ("Jyoti Seth" <jyotiseth2001@gmail.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: "Jyoti Seth"
Date:
Subject: setof or array as input parameter to postgresql 8.2 functions
Next
From: "A. R. Van Hook"
Date:
Subject: join problem