| Tony S 2005-12-13, 8:25 pm |
| Alvaro Herrera wrote:
> Stallone wrote:
>
> Please keep replies on the list.
>
>
>
>
> 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
|