Re: What does "merge-joinable join conditions" mean ????

On 2006-01-15 13:54, Michael Fuhr wrote:
> What's the query?
>   

SELECT count(*)  FROM "GenAppExtra" FULL JOIN  "GeoRestrict" ON callsign 
~ pattern  WHERE region_id = 4 OR geo_region = 4;

If either of the "region_id = 4"  (a field in the right-hand table) or 
"geo_region = 4" (a field in the left-hand table) are removed, the 
SELECT functions (does not give an error message), as does the case 
where the "callsign ~ pattern" (one field is from each table) is 
replaced by "callsign = pattern".

What's frustrating is that both tables are small, and "GeoRestrict" is 
only about 15 rows.

At this point, I'm considering a UNION;  alternate suggestions welcome!

-- Dean