Thread: plpgsql parameters

plpgsql parameters

From
"FERREIRA, William (VALTECH)"
Date:
Hi,

i have a recursive function building a xml file, from differents table.
the xml is stored in memory and then flush on disk.
the xml text is used in each recursive calls and i would like to know if in plpqsql parameters are passed by reference,
orif there is a key word for passing parameters by reference. 

regards

will


This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.

Re: plpgsql parameters

From
Richard Huxton
Date:
FERREIRA, William (VALTECH) wrote:
> Hi,
>
> i have a recursive function building a xml file, from differents
> table. the xml is stored in memory and then flush on disk. the xml
> text is used in each recursive calls and i would like to know if in
> plpqsql parameters are passed by reference,

I don't believe so.

 > or if there is a key word
> for passing parameters by reference.

No.

Some of the other procedural languages allow you to have a "global" (to
the connection) data space. That might be useful in your case.

--
   Richard Huxton
   Archonet Ltd