From: | Anand Raman <araman(at)india-today(dot)com> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | strange query results |
Date: | 2001-02-12 07:05:58 |
Message-ID: | 20010212123558.E22384@india-today.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | fabrizio.ermini | 2001-02-12 09:27:04 | Error from index "pg_type_typname_index"???? |
Previous Message | Jarungwit J. | 2001-02-12 05:56:04 | Re: startup Postgres on NT |