Search Postgresql Archives

Re: Need help with INOUT mis-understanding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Probably not, if the way you seem to expect it to work is like Oracle.
> An INOUT parameter isn't some sort of modifiable by-reference variable,
> it's just a shorthand for declaring an IN parameter and an OUT
> parameter.
>

Thanks for the response.

That makes a lot of sense but I guess I was wishing to make it work in
porting all the oracle pl/sql.

If I have a function with 3 INOUTs and I get a return of (30,20,1) how
should I structure it so I can read only the "1" from another function
call? Should I be doing SETOF? I just haven't figured how to parse
results within functions.. any suggestions for me?

Thank you
Troy


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux