Re: select distinct error ? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: select distinct error ?
Date
Msg-id 20020725082306.S48415-100000@megazone23.bigpanda.com
Whole thread Raw
In response to select distinct error ?  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
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?





pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Problematic Index Scan
Next
From: "Jeff MacDonald"
Date:
Subject: Re: erserver