Re: Functions returning setof record -- can I use a table type as my return type hint?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: George MacKerron <g(dot)j(dot)mackerron(at)lse(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Functions returning setof record -- can I use a table type as my return type hint?
Date: 2011-08-12 16:44:00
Message-ID: 4E455850.7020701@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/08/2011 17:26, George MacKerron wrote:
> Many thanks for the reply, Ray.
>
> Unfortunately, I don't think this addresses the problem, because I'd
> hoped not to have to hard-code the table name into the function.
>
> The point of the function is that you can pass it any table name
> (along with some other parameters) and it returns rows from that
> named table.

OK, fair enough.... but what exactly are you trying to do that a simple
SELECT won't do?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-08-12 16:44:14 Re: Functions returning setof record -- can I use a table type as my return type hint?
Previous Message Merlin Moncure 2011-08-12 16:43:20 Re: Functions returning setof record -- can I use a table type as my return type hint?