eTable, otherinfo varchar);
then change `r record;` to `r foo_result;` , no need change `foo` itself,
and it works now.
I don't know is this the best way to do this though.
>
> regards
>
> Pavel
>
> 2012/5/30 yi huang :
> > I'm porting a oracle function to
On Wed, May 30, 2012 at 12:36 PM, yi huang wrote:
> Thanks for you quick reply, but i need to take this returned row in
> another pgsql function and do further processing.
Sorry, i was misunderstood, i get it now, just use a record type, thanks
very much.
>
>
> On Wed, May 30
> r := foo('Hello');
> raise notice ''% %', r.somerow, r.otherinfo;
> end;
> $$ language plpgsql;
>
> regards
>
> Pavel
>
> 2012/5/30 yi huang :
> > I'm porting a oracle function to postgresql, which has signature like
>
I'm porting a oracle function to postgresql, which has signature like this:
FUNCTION foo
( seq IN varchar
, somerow OUT SomeTable
, otherinfo OUT varchar
)
It's easy to port this function itself to postgresql, but i have problem to
execute this function and assign the result
ation failed for user "zlfund"
> 2012-05-19 16:09:34 CST ??: ???(zlfund)(huangyi) ???
> 2012-05-19 16:09:34 CST : Peer authentication failed for user "zlfund"
I guess it has something to do with packaging problem rather than
postgresql itself, but it would be great if you can give me some clue where
the problem might be.
My best regards.
Yi Huang.
