• Tom Lane's avatar
    Cause CHAR(n) to TEXT or VARCHAR conversion to automatically strip trailing · f45df8c0
    Tom Lane authored
    blanks, in hopes of reducing the surprise factor for newbies.  Remove
    redundant operators for VARCHAR (it depends wholly on TEXT operations now).
    Clean up resolution of ambiguous operators/functions to avoid surprising
    choices for domains: domains are treated as equivalent to their base types
    and binary-coercibility is no longer considered a preference item when
    choosing among multiple operators/functions.  IsBinaryCoercible now correctly
    reflects the notion that you need *only* relabel the type to get from type
    A to type B: that is, a domain is binary-coercible to its base type, but
    not vice versa.  Various marginal cleanup, including merging the essentially
    duplicate resolution code in parse_func.c and parse_oper.c.  Improve opr_sanity
    regression test to understand about binary compatibility (using pg_cast),
    and fix a couple of small errors in the catalogs revealed thereby.
    Restructure "special operator" handling to fetch operators via index opclasses
    rather than hardwiring assumptions about names (cleans up the pattern_ops
    stuff a little).
    f45df8c0
select_having.out 1.33 KB