Suggestion

Hi. I did not find the email referring to suggestions for improvement on
the site so I sent it to this email.

I miss two features that exist in the Oracle database but are not in
PostgreSQL.

1 - PIVOT and UNPIVOT

2 - UPDATE SET ROW

In Oracle it is possible to update a table with a ROWTYPE using the ROW. In
PostgreSQL it shows the following error: column "row" of relation
"my_table" does not exist.

Ex: update padrao.pessoa_fisica_rg
set row = (select p_rc_pessoa_fisica_rg.*)
where id = p_rc_pessoa_fisica_rg.id;

https://docs.oracle.com/database/121/LNPLS/composites.htm#LNPLS99929
http://psoug.org/definition/ROW.htm
https://stackoverflow.com/questions/43791535/updating-a-row-using-a-rowtype-variable-in-postgres
https://www.postgresql.org/message-id/003d01cc966c%2467f4c2b0%2437de4810%24%40com.co

Is there any release for these two features?

Att,
Anderson Antunes