strange query results

Поиск
Список
Период
Сортировка
От Anand Raman
Тема strange query results
Дата
Msg-id 20010212123558.E22384@india-today.com
обсуждение исходный текст
Ответы Re: strange query results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
hi guys
I am trying out some relativly simple queries against my database..

select distinct site_section as "distinct site sections" from exhibit_distributions ;
distinct site sections
------------------------
ARCHIVED
ARTETC
CALENDAR
GALLERY
POSTCARD
(5 rows)


select site_section, count(*) from exhibit_distributions group by site_section;
site_section | count
--------------+-------
    |   352
      |    45
    |     1
     |   166
    |     2

The second query is not priniting out site_section column.. This is
happening in 3 seperate dbs (702 and 703).. Can any one point out the
mistake.

This is proving to be a show stopper .. We arent able to select rows for
a particular site_section..

Thanks for your response
Anand

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

Предыдущее
От: "Arun Malhotra - Roll No.99007"
Дата:
Сообщение: Re: selecting a random record
Следующее
От: fabrizio.ermini@sysdat.it
Дата:
Сообщение: Error from index "pg_type_typname_index"????