Re: select as params to function

On 2/17/2012 2:49 PM, Merlin Moncure wrote:
> 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
>

Oh, I see, I need to change my function too.

Thanks,

-Andy