Suggestion
| От | Anderson Antunes |
|---|---|
| Тема | Suggestion |
| Дата | |
| Msg-id | CAAHHTi-Uo8d94zuV3eNq7fHMr7bMViJEZ_un0=TDODSeOPt3_g@mail.gmail.com обсуждение исходный текст |
| Список | pgsql-bugs |
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?
Att,
Anderson Antunes
В списке pgsql-bugs по дате отправления: