select from composite type

From: Lorusso Domenico <domenico(dot)l76(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: select from composite type
Date: 2024-02-04 22:50:33
Message-ID: CAJMpnG4nv+itZ8SA5R0MPevOtnzkNaRhCuFcZk+hZR7UzHdD9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

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

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-02-04 23:15:10 Re: How to do faster DML
Previous Message veem v 2024-02-04 21:39:56 Question on partitioning