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?