Re: select distinct error ?

On Thu, 25 Jul 2002, Henrik Steffen wrote:

> select distinct foo from bar where foobar like 'foobar%';
>
> gives:
>
>  foo
> --------
>  090700
>  090701
>  090702
>  090700
> (4 rows)
>
> foo is character(6)
>
> How can this happen??

Do you have a simple dataset that you can replicate this with
that you can send a dump of (tables, data).  Also, what version
and what locale are you running with?