Re: [HACKERS] Re: PL/PgSQL discussion - Mailing list pgsql-hackers

From jwieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] Re: PL/PgSQL discussion
Date
Msg-id m0yEUK7-000BFRC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: PL/PgSQL discussion  (Hannu Krosing <hannu@trust.ee>)
List pgsql-hackers
Hannu Krosing wrote:
>
> And another thing:
>
> Does'nt the Oracle PL/SQL have both input and input/output parameters ?
>
> It's more than a year since i last used it but I think that this is the case.

    Right,  they  have.  But  PostgreSQL  doesn't and so PL/pgSQL
    can't.  PL/pgSQL cannot do any thing that  a  C  function  in
    PostgreSQL cannot do. The PL handler is written in C and that
    is what the executor calls instead of the compiled  function.
    From  the  backends point of view, a PL handler is just one C
    function with a bunch of personalities.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] varchar() vs char16 performance
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] Re: PL/PgSQL discussion