On Thu, May 7, 2009 at 2:21 AM, Maximilian Tyrtania
<maximilian.tyrtania@onlinehome.de> wrote:
> Hi there,
>
> does this look right?
>
> FAKDB=# select count(distinct(f.land)) from firmen f where
> f.typlist='Redaktion';
> count
> -------
> 1975
> (1 row)
>
> FAKDB=# select count(distinct(f.land||'1')) from firmen f where
> f.typlist='Redaktion';
> count
> -------
> 4944
> (1 row)
Yeah, that does seem odd. Could it be something like nulls in your
data set? just guessing really. If you could make a small test case
that shows it happening and allows others to reproduce it you're
likely to get more bites.