strange query results - Mailing list pgsql-general

From Anand Raman
Subject strange query results
Date
Msg-id 20010212123558.E22384@india-today.com
Whole thread Raw
Responses Re: strange query results  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Arun Malhotra - Roll No.99007"
Date:
Subject: Re: selecting a random record
Next
From: fabrizio.ermini@sysdat.it
Date:
Subject: Error from index "pg_type_typname_index"????