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

From: "Henrique Pantarotto" <pantarotto(at)terra(dot)com(dot)br>
To: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
Cc: <pgsql-general(at)hub(dot)org>
Subject: RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Date: 2000-02-28 18:20:06
Message-ID: NDBBKPBFKLCBCDCDMPOLEEDNCBAA.pantarotto@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)terra(dot)com(dot)br
<Hatuna Matata, é liiiinndo dizer!>

> -----Original Message-----
> From: Ross J. Reedstrom [mailto:reedstrm(at)wallace(dot)ece(dot)rice(dot)edu]
> Sent: Monday, February 28, 2000 1:00 PM
> To: Henrique Pantarotto
> Cc: pgsql-general(at)hub(dot)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(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!>
> > >
> > >
> > >
> > > ************
> > >
> >
> >
> > ************
> >

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sandro Dentella 2000-02-28 19:21:57 Keeping 2 db updated each-other
Previous Message Jackson, Kevin J. 2000-02-28 18:10:34 What is wrong with this query?