Re: Proposal: real procedures again (8.4)

2007/10/27, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> > "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> >> Why new calling convention? I would to support byref variables and
> >> then I have to carry memory context info ... and maybe some others
>
> > I think first you have to invent something for the by-ref parameter to refer
> > to.
>
> Most of that sounded to me like a proposal to re-invent ecpg. If there
> were such a large demand for doing things that way, there would be many
> more users of ecpg than bare libpq. AFAICT, though, *very* few people
> use ecpg.
>

With procedures we can be in conformance with ANSI standard and others
databases. New SQL2006 standards contains lot of SQL/PSM code and will
be usefull, if we can port this code without changes.

New calling convention can simplify life. It can support more than one
output value. Actual solution is practical, but is too complicated for
C code, because I have to do create tuple when I would to return two
ints ...

Pavel