Re: Weird behavior with custom operators - Mailing list pgsql-general

Matthieu HUIN <matthieu.huin@wallix.com> writes:
> xxx=> SELECT value FROM tags WHERE value > 3 LIMIT 1;
> ERROR:  unsupported type: 17886

I think you're probably hitting this:

    /*
     * Can't get here unless someone tries to use scalarltsel/scalargtsel on
     * an operator with one numeric and one non-numeric operand.
     */
    elog(ERROR, "unsupported type: %u", typid);

While you could possibly make it work by writing wrappers around those
selectivity functions instead of using them directly, I'm kind of
wondering what is the point of this datatype anyway?  Seems like
declaring it as a domain over text might be easier.

            regards, tom lane