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

Поиск
Список
Период
Сортировка
От sunpeng
Тема why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?
Дата
Msg-id k2s46cc57ac1005041218n681b1608x789f5f47e965a4eb@mail.gmail.com
обсуждение исходный текст
Ответы Re: why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I've the table
CREATE TABLE pois
(
   uid integer not null,
   name VARCHAR(128),
   catcode VARCHAR(32)  not null,
   catname VARCHAR(32),
   others VARCHAR(32)
);
after i execute "select count(*) from pois group by catcode";
the log of query.targetList is :
:targetList (
          {TARGETENTRY
          :expr
             {AGGREF
             :aggfnoid 2803
             :aggtype 20
             :args <>
             :agglevelsup 0
             :aggstar true
             :aggdistinct false
             :location 7
             }
          :resno 1
          :resname count
          :ressortgroupref 0
          :resorigtbl 0
          :resorigcol 0
          :resjunk false
          }
          {TARGETENTRY
          :expr
             {VAR
             :varno 1
             :varattno 3
             :vartype 1043
             :vartypmod 36
             :varlevelsup 0
             :varnoold 1
             :varoattno 3
             :location 35
             }
          :resno 2
          :resname <>
          :ressortgroupref 1
          :resorigtbl 0
          :resorigcol 0
          :resjunk true
          }
       )
why there is the second TARGETENTRY? what's the purpose of the second TARGETENTRY?

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: why there are two TargetEntrys in Query when i use "select count(catcode) from pois group by catcode"?