Re: return two elements - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: return two elements
Date
Msg-id 20050607172153.GE17902@surnet.cl
Whole thread Raw
In response to Re: return two elements  (Michael Fuhr <mike@fuhr.org>)
Responses Re: return two elements  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: peter royal
Date:
Subject: Re: locking question - why is this not a deadlock?
Next
From: Scott Marlowe
Date:
Subject: Re: Issue with adding ORDER BY to EXCEPT.