Thread: 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;

Is there any release for these two features?