How to determine the operator class that an operator belongs to

Started by Marc Munroover 16 years ago2 messagesgeneral
Jump to latest
#1Marc Munro
marc@bloodnok.com

I'm trying to reconstruct create operator class statements from the
catalogs. My problem is that access method operators are related only
to their operator families.

My current assumtion is that all operators for an operator class will
have the same left and right operand types as the data type (opcintype)
of the operator class, or will be None.

Here is my query:
-- List all operator family operators.
select am.amopfamily as family_oid,
oc.oid as class_oid
from pg_catalog.pg_amop am
inner join pg_catalog.pg_operator op
on op.oid = am.amopopr
left outer join pg_catalog.pg_opclass oc
on oc.opcfamily = am.amopfamily
and (oc.opcintype = op.oprleft or op.oprleft = 0)
and (oc.opcintype = op.oprright or op.oprright = 0)

Is my assumption correct? Does the query seem correct?

Thanks in advance.

__
Marc

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Marc Munro (#1)
Re: How to determine the operator class that an operator belongs to

Marc Munro <marc@bloodnok.com> writes:

I'm trying to reconstruct create operator class statements from the
catalogs. My problem is that access method operators are related only
to their operator families.

That's because operators might not be in any class.

If you really want to find this out, look in pg_depend for linkages
from operators to classes.

regards, tom lane