Suggestion

Started by Anderson Antunesalmost 8 years ago1 messagesbugs

Jump to latest

Anderson Antunes

anderson.ant.oli@gmail.com

almost 8 years ago

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
/messages/by-id/003d01cc966c$67f4c2b0$37de4810$@com.co

Is there any release for these two features?

Att,
Anderson Antunes