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
