RE: RES: [GENERAL] Stored procedures returning multiple values... ? - Mailing list pgsql-general

From Henrique Pantarotto
Subject RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Date
Msg-id NDBBKPBFKLCBCDCDMPOLEEDNCBAA.pantarotto@terra.com.br
Whole thread Raw
In response to Re: RES: [GENERAL] Stored procedures returning multiple values... ?  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
Responses How to speed up commits?  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List pgsql-general
Ross, thank you for your reply!

Pgsql developers has done a great job so far, and I am sure things will keep
like that.


Thanks and regards from Brazil,
___________________________________________
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@terra.com.br
<Hatuna Matata, é liiiinndo dizer!>


> -----Original Message-----
> From: Ross J. Reedstrom [mailto:reedstrm@wallace.ece.rice.edu]
> Sent: Monday, February 28, 2000 1:00 PM
> To: Henrique Pantarotto
> Cc: pgsql-general@hub.org
> Subject: 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@rice.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@postgreSQL.org
> > > [mailto:owner-pgsql-general@postgreSQL.org]Em nome de Henrique
> > > Pantarotto
> > > Enviada em: Sexta-feira, 25 de Fevereiro de 2000 09:27
> > > Para: pgsql-general@hub.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@terra.com.br
> > > <Hatuna Matata, é liiiinndo dizer!>
> > >
> > >
> > >
> > > ************
> > >
> >
> >
> > ************
> >


pgsql-general by date:

Previous
From: "Jackson, Kevin J."
Date:
Subject: What is wrong with this query?
Next
From: Sandro Dentella
Date:
Subject: Keeping 2 db updated each-other