Re: strange query results

HI tom
A few days back i had bugged this list about the seemingly impossible
select queries results..

##RECAP##
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

##RECAP##

On going thru the flat files which we used to uplaod the database we
noticed a few fields had '' characters to signify '.. This was creating
problems in some jdbc queries.

One changing them to single ' and reloading all the data, the problem
simply disappered..

Thanks for the help
Anand Raman
On Tue, Feb 13, 2001 at 10:20:53AM -0500, Tom Lane wrote:
>Anand Raman <araman@india-today.com> writes:
>> The table description is as follows
>
>Hmm ... nothing obviously funny here.  Is there anything unusual about
>the history of this table?  (For example, were site_section or any other
>columns added via ALTER TABLE, rather than being there all along?)
>
>            regards, tom lane