Re: RES: [GENERAL] Stored procedures returning multiple values... ?

Henrique -
No, not stupid, just hard. I find it interesting that I read your
repost of your question immediately following a pair of postings to the
PGSQL-HACKERS list by Karel Zak about his implementation of cached/stored
procedures. ;-)

As it stands, the "stored procedures" in pgsql are really user defined
functions, and can only return values. Changing that is a major amount
of work, and hasn't happened for 7.0 (or 7.1) Karel Zak's work is also
post 7.0, I believe, unless The Powers That Be (the core developers)
decide that his changes are sufficently isolated s othat any bugs are
unlikely to affect other code.

In other words, no not yet, but soon!

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

On Mon, Feb 28, 2000 at 08:53:09AM -0300, Henrique Pantarotto wrote:
> Is my question stupid? ;-)
>
> > -----Mensagem original-----
> > De: owner-pgsql-general(at)postgreSQL(dot)org
> > [mailto:owner-pgsql-general(at)postgreSQL(dot)org]Em nome de Henrique
> > Pantarotto
> > Enviada em: Sexta-feira, 25 de Fevereiro de 2000 09:27
> > Para: pgsql-general(at)hub(dot)org
> > Assunto: [GENERAL] Stored procedures returning multiple values... ?
> >
> >
> > Hello friends,
> >
> > many months ago I starting messing with stored procedures with PostgreSQL,
> > and at the time, I found out that I could only return "one" value when I
> > used a stored procedure.
> >
> > I was wondering if this has changed or has/will/could be
> > changed/implemented
> > with PostgreSQL 7.0?
> >
> > It would be fun if stored procedured could return multiple
> > values, wouldn't
> > it? ;-)
> >
> >
> > Thanks,
> > ___________________________________________
> > Henrique Pantarotto
> > Administrador de Sistemas - SITE São Paulo
> > Terra Networks Brasil S/A
> > A Internet do Brasil agora é TERRA
> > Tel: (11) 5505-5728 r.214/260/238
> > ICQ: 6934285
> > pantarotto(at)terra(dot)com(dot)br
> > <Hatuna Matata, é liiiinndo dizer!>
> >
> >
> >
> > ************
> >
>
>
> ************
>