Re: select from composite type

On 2/4/24 14:50, Lorusso Domenico wrote:
> Hello guys,
> I'm trying to find out the equivalent behaviour of unnest, when I've got 
> just a composite type.
> 
> This is the statement is something like that (but more complex):
> 
>   _sqlUpdate text=$$
> with s as (
> select * from ($1)
> )
> update myView as q set
> (attribute_fullname, modify_user_id)
> =(s.attribute_fullname, $2)
> where  s.product_code=q.product_code
> and s.attribute_uid=q.attribute_uid
> $$;
> 
> And I use this command.
> execute _sqlUpdate using  attribute_list[_i], _modify_user_id;

Is the above in a plpgsql function?

> 
> attribute_list is  an array of composite type (with 20 fields).

I am trying to wrap my head around "array of composite type". Please 
provide an example.


> 
> If I use the unnest with the entire array the sql works, but I can't 
> find a way to treat the single record as a row of  a table.
> 
> 
> Any suggestions?
> 
> Bye and thanks'
> 
> Domenico

-- 
Adrian Klaver
adrian.klaver@aklaver.com