"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> I have a FULL JOIN between two simple tables, and am getting the message
> " Query failed: ERROR: FULL JOIN is only supported with merge-joinable
> join conditions"
> I'd be glad to fix this in my query if I knew what the [EMAIL PROTECTED] it
> meant.
The join condition(s) of a FULL JOIN have to be mergejoinable, which
basically means an equality relation between sortable (btree-indexable)
data types. You can see exactly which operators are mergejoinable with
a query like
select oid::regoperator from pg_operator where oprlsortop != 0;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
