Is it possible to get DISTINCT rows from RETURNING clause?

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Is it possible to get DISTINCT rows from RETURNING clause?
Дата
Msg-id 003d01cbce71$1eaf1c90$5c0d55b0$@com
обсуждение исходный текст
Ответы Re: Is it possible to get DISTINCT rows from RETURNING clause?  ("Gnanakumar" <gnanam@zoniac.com>)
Список pgsql-sql
Hi,

Is it possible to get DISTINCT rows from an UPDATE statement using RETURNING
clause?

"MYTABLE" columns are:APRIMARYKEYCOLUMNABOOLEANCOLUMNEMAILCOLUMN1COLUMN2COLUMN3

UPDATE using RETURNING clause query:
UPDATE MYTABLE SET ABOOLEANCOLUMN = true FROM MYTEMPTABLE WHERE EMAIL =
MYTEMPTABLE.EMAIL RETURNING EMAIL, COLUMN1, COLUMN2, COLUMN3;

Here in this case, I expect to return distinct rows from these columns:
EMAIL, COLUMN1, COLUMN2, COLUMN3. 

I even tried out some ways of getting distinct rows, but it doesn't work.
Though I can still solve this at application layer, I'm trying to find
whether this could be controlled at query-level.  Any different
ideas/suggestions are appreciated.

Regards,
Gnanam



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

Предыдущее
От: Rok Jaklič
Дата:
Сообщение: Re: After insert trigger and select
Следующее
От: Andreas Forø Tollefsen
Дата:
Сообщение: ARRAY_AGG and COUNT