Re: Function returning any (tuple) type - Mailing list pgsql-general

From Richard Huxton
Subject Re: Function returning any (tuple) type
Date
Msg-id 42D77DB1.1030703@archonet.com
Whole thread Raw
In response to Re: Function returning any (tuple) type  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
Hannes Dorbath wrote:
> On 15.07.2005 08:51, Ezequiel Tolnay wrote:
>
>>
>> The main problem I see is that the funcitions in PostgreSQL seem to be
>> always bound to a particular result datatype. Is there a way to
>> circumvent this?
>
>
> I tried to find a solution for this as well some time ago. I don't
> believe there is a practical way. It's only a guess, maybe this "strong
> typing" helps the planer / optimizer in some way..

If that's not what you want, you can always return text (structure it
how you like) or a cursor-reference.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Function returning any (tuple) type
Next
From: "Andrus"
Date:
Subject: How to create unique constraint on NULL columns