RE: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values

Поиск
Список
Период
Сортировка
От 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  (Francisco Olarte <folarte@peoplecall.com>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17219: Create table not working
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: GROUP BY using tablename.* does not work if tablename has 1 column with NULL values