Re: why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?
Дата
Msg-id 19561.1273005336@sss.pgh.pa.us
обсуждение исходный текст
Ответ на why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?  (sunpeng <bluevaley@gmail.com>)
Список pgsql-general
Дерево обсуждения 
sunpeng <bluevaley@gmail.com> writes:
> after i execute "select count(*) from pois group by catcode";
> the log of query.targetList is :
> why there is the second TARGETENTRY? what's the purpose of the second
> TARGETENTRY?

It's the GROUP BY expression.  Note the ressortgroupref and resjunk
settings.

            regards, tom lane

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

Предыдущее
От: sunpeng
Дата:
Сообщение: why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?
Следующее
От: Andre Lopes
Дата:
Сообщение: How to exit/abort from a function that returns VOID?