Re: [BUGS] BUG #2108: Function with OUT parameters not recognized,

#1

Alvaro Herrera wrote:

Quote:

Stallone wrote:

Please keep replies on the list.

What you have done is run a SELECT which evaluates the function
f_multiparam() passing it two parameters, and then takes the result and
puts it INTO a local parameter. This is not the same. An OUT parameter
is actually passed to the function and is part of the function
specification, in this case it is defined as the third parameter. It's
like a placeholder within the definition of the function itself, and it
should show up on the list of parameters for that function. You can, in
fact, have many OUT parameters in one function. This is an advantage of
out parameters over just a plain function with a single RETURN element.

At least this is how it has always worked for me.

Has always worked where? In Postgres? It's strange that you mention
"always" because OUT parameters are new in Postgres 8.1. Behavior in
other database systems is not directly applicable to Postgres.

Keep in mind that in Postgres we don't have host variables, which is
what is needed to make OUT params work the way you are assuming they do.
This could be improved in the future but currently that's the way it is.

I have seriously mistaken the nature of IN/OUT parameters in Postgres.

This misunderstanding all leaked over from Oracle and is not applicable
at all here. Maybe this might make a good bullet point to add in Sec
36.11 "Porting from Oracle PL/SQL". I will post a note separately there.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2108: Function with OUT parameters not recognized,

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2108: Function with OUT parameters not recognized, - 12-13-2005 , 07:14 PM