Erwin Brandstetter <brsaweda@xxxxxxxxx> writes: > Guess Tom's warning in > https://www.postgresql.org/message-id/9434.1568839177@xxxxxxxxxxxxx about > portability only refers to hashtextextended() and friends not being there > in Postgres 10 or older. Well, the other portability issue that is worth considering is that these functions are only intended to give stable results within a particular installation; their use for hash indexes does not require the same results across different platforms. Notably, most of them give different answers on little-endian and big-endian machines. That's not necessarily a reason not to use them, but you have to be careful what you assume about them. regards, tom lane
