RE: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values
В списке pgsql-bugs по дате отправления:
| От | Narayanan Iyer |
|---|---|
| Тема | RE: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values |
| Дата | |
| Msg-id | 14b101d7be98$ed5731e0$c80595a0$@yottadb.com обсуждение |
| Ответ на | Re: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values (Francisco Olarte <folarte@peoplecall.com>) |
| Ответы |
Re: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values
|
| Список | pgsql-bugs |
Francisco, Sorry about the quoting style. I am used to including the original email in my response for better context. Did not realizethat would get pasted in the discussion thread. I don't have a way of editing it. If you do, please remove those prioremails in my response. You are right. My inner query was an outer join returning 3 rows. But what I did not understand was that the NULLs in 2 ofthe 3 rows were different because 1 was a composite NULL and 1 was a ROW(NULL) and hence they showed up as 2 differentNULLs/rows even after a GROUP BY. Tom's explanation cleared it up for me. So no issues. Like I mentioned in another response, please close this bug report. I don't think I can. Narayanan.
В списке pgsql-bugs по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера