am 09.05.2009 16:33 Uhr schrieb Tom Lane unter t...@sss.pgh.pa.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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
