From: | Maximilian Tyrtania <maximilian(dot)tyrtania(at)onlinehome(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Distinct oddity |
Date: | 2009-05-13 12:37:43 |
Message-ID: | C6308BB7.3611D%maximilian.tyrtania@onlinehome.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
am 09.05.2009 16:33 Uhr schrieb Tom Lane unter tgl(at)sss(dot)pgh(dot)pa(dot)us:
> What you need to do is
> dump out the *entire* results of the DISTINCT queries and look for the
> unmatched lines. I'd try dumping to two files, stripping the 'e' with
> sed, and then sort/diff.
Okay, that's what I did, and the results are, well, surprising (for me, mind
you).
FAKDB=# \o /withapp
FAKDB=# select distinct f.bezeichnung||'$' from firmen f order by 1;
FAKDB=# \o /withoutapp
FAKDB=# select distinct f.bezeichnung from firmen f order by 1;
Opened those files (with textwrangler, as I 've never used sed), stripped
off the '$', sorted and looked at the differences (using textwranglers
"compare documents"-feature).
The file "withoutapp" has those lines:
"Abendschau"
"Abendschau"
They don't look distinct to me. The "Abendschau"-Entry appears only once in
"withapp". But then again the "withapp" file has these entries:
Adformatie
Adformatie
which in turn only appear once in "withoutapp". I turned "show invisibles"
on in textwrangler, so I don't think there is some gremlin business going
on.
Actually I'm interested in but in no way dependant on what's going on here,
I just thought as a good pg-citizen I should report whatever might be wrong.
Best,
Maximilian Tyrtania
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-05-13 14:47:58 | Re: Distinct oddity |
Previous Message | Maximilian Tyrtania | 2009-05-12 18:29:36 | Re: Distinct oddity |