From: | "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: return two elements |
Date: | 2005-06-08 07:11:39 |
Message-ID: | B35596C2EFF3D2118EE100A0C94B2A60014BFBE0@palamos_nt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
For my it would be sufficient that I could return a basic type in OUT/INOUT
parameters, if in addition I could return a set ... fantastic!
-----Mensaje original-----
De: Alvaro Herrera [mailto:alvherre(at)surnet(dot)cl]
Enviado el: martes 7 de junio de 2005 19:22
Para: Michael Fuhr
CC: Rodríguez Rodríguez,Pere; pgsql-general(at)postgresql(dot)org
Asunto: Re: [GENERAL] return two elements
On Tue, Jun 07, 2005 at 07:45:03AM -0600, Michael Fuhr wrote:
> On Tue, Jun 07, 2005 at 10:08:27AM +0200, "Rodríguez Rodríguez, Pere"
wrote:
> >
> > I suppose that IN/OUT declaration also will use with procedural language
> > (PL/pgSQL), it's correct?
>
> Yes; INOUT is also supported.
Hmm, be aware that you can't return a set if you have OUT/INOUT
parameters. Apparently this is something people coming from Oracle/SQL
Server expect to be able to do.
--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Cada quien es cada cual y baja las escaleras como quiere" (JMSerrat)
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-06-08 08:14:14 | Re: blocking INSERTs |
Previous Message | Neil Conway | 2005-06-08 06:12:04 | Re: Postgres 8.0.1 configure failed |