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.*)


Is there any release for these two features?

Att,
Anderson Antunes

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #15256: Comparing if a rowtype is null
Следующее
От: Nelson Castiblanco
Дата:
Сообщение: PgAdmin - AlertityjS - Query Tool Initialize Error