Skip site navigation (1) Skip section navigation (2)

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

From: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
To: Henrique Pantarotto <pantarotto(at)terra(dot)com(dot)br>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: RES: [GENERAL] Stored procedures returning multiple values... ?
Date: 2000-02-28 15:59:40
Message-ID: 20000228095940.A6978@rice.edu (view raw or flat)
Thread:
Lists: pgsql-general
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

pgsql-general by date

Next:From: Ed LoehrDate: 2000-02-28 16:06:29
Subject: [GENERAL] RFC: Experiences with EARP?
Previous:From: Ed LoehrDate: 2000-02-28 15:52:26
Subject: Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group