Re:

From: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
To: Nigel Horne <njh(at)bandsman(dot)co(dot)uk>, Tino Wildenhain <tino(at)wildenhain(dot)de>
Cc: "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re:
Date: 2005-08-22 14:37:38
Message-ID: BF2FA1C2.4B3D3%awitney@sgul.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22/8/05 2:56 pm, "Nigel Horne" <njh(at)bandsman(dot)co(dot)uk> wrote:

> On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
>> Nigel Horne schrieb:
>>> On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
>>>
>>>> am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
>>>>
>>>>> I can't work out from that how to return more than one value.
>>>>
>>>> 17:35 < rtfm_please> For information about srf
>>>> 17:35 < rtfm_please> see
>>>> http://techdocs.postgresql.org/guides/SetReturningFunctions
>>>> 17:35 < rtfm_please> or
>>>> http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835
>>>
>>>
>>> How does that help with my problem? I seems to discuss returning more
>>> than one row of a table which is not the question I asked.
>>>
>>
>> try to tell your questions more precisely :-)
>
> I want to return more than one value from a procedure, e.g. a string and
> an integer.
>
>> I think you want to return a record or tabletype.
>
> Not really, since those values could be computed on the fly, they may
> not be values in a database.
>
>> IIrc you got the answers to that already :-)
>
> Nope.

Hi Nigel,

Well if you have not yet received the answer that you require, then you
probably haven't asked your question properly.... Because several people
have answered the question as you stated it.

You might have to be more specific about your requirements to get a proper
answer.

Cheers

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

  • Re: at 2005-08-22 13:56:09 from Nigel Horne

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-08-22 14:47:40 Re:
Previous Message Stephan Szabo 2005-08-22 14:27:41 Re: SQL error - please help.