> Apparently the first 6 characters of those fields are quite common, which > gives you a result for every possible combination of the same 6-character > value.
Mmmmm. That seems kind of weird. Is there any way to NOT have this be a cross join? For example if I extracted the first six characters into a field and then joined on them it would not be a cross join right? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
