Re: SQL-spec incompatibilities in similar_escape() and related stuff

Robert Haas <robertmhaas@gmail.com> writes:
> I think it's pretty clear that the theoretical beauty of being able to
> handle postfix operators is not worth the tangible cost they impose on
> our parser.  We're losing more users as a result of SQL that other
> systems can accept and we cannot than we are gaining by being able to
> support user-defined postfix operators.

I suppose it's possible to make such an argument, but you haven't
actually made one --- just asserted something without providing
evidence.

If we can lay out some concrete gains that justify zapping postfix
operators, I'd be willing to do it.  I agree that it would likely
hurt few users ... but we need to be able to explain to those few
why we broke it.  And show that the benefits outweigh the cost.

            regards, tom lane