• Tom Lane's avatar
    Fix pg_get_ruledef() so that negative numeric constants are parenthesized. · c1943dba
    Tom Lane authored
    This is needed because :: casting binds more tightly than minus, so for
    example -1::integer is not the same as (-1)::integer, and there are cases
    where the difference is important.  In particular this caused a failure
    in SELECT DISTINCT ... ORDER BY ... where expressions that should have
    matched were seen as different by the parser; but I suspect that there
    could be other cases where failure to parenthesize leads to subtler
    semantic differences in reloaded rules.  Per report from Alexandr Popov.
    c1943dba
ruleutils.c 143 KB