Postgres Pro
Downloads
Home   >   mailing lists

Re: select as params to function - Mailing list pgsql-general

From Merlin Moncure
Subject Re: select as params to function
Date
Msg-id CAHyXU0zghmwVDy1XmUvWqAPNAzKu0C9kL0S3LA9JQWB5BXZxtw@mail.gmail.com
Whole thread Raw
In response to Re: select as params to function  (Andy Colson <andy@squeakycode.net>)
Responses Re: select as params to function  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view 
On Fri, Feb 17, 2012 at 2:32 PM, Andy Colson <andy@squeakycode.net> wrote:
> On 2/17/2012 2:11 PM, Pavel Stehule wrote:
>>
>> Hello
>>
>> PostgreSQL has no table data type. You can use a array of records instead
>>
>> and then
>>
>> select fx((select array(select * from tab)));

select fx(array(select t from tab t));

fx takes tab[]

merlin

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: select as params to function
Next
From: Andy Colson
Date:
Subject: Re: select as params to function