On 12-06-21 12:18 PM, Tom Lane wrote:
Did you actually create a "text = chkpass" function and operator? This declaration merely promises that you will provide one eventually. The system does not have the ability to make one for you.
I guess I am missing the point of COMMUTATOR then. The docs say "When you are defining a self-commutative operator, you just do it." It seems you need to do more than "just do it." As far as I can tell I will need to add another C function and another CREATE OPERATOR. Then I can create an operator that takes args (text, chkpass) instead of (chkpass, text). What is the COMMUTATOR for then? Is it just a hint to the planner? -- D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. IM: da...@vex.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
