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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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!>
> >
> >
> >
> > ************
> >
>
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2000-02-28 16:06:29 | [GENERAL] RFC: Experiences with EARP? |
Previous Message | Ed Loehr | 2000-02-28 15:52:26 | Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0) |