Erwin Brandstetter <brsaweda@gmail.com> writes:
> Guess Tom's warning in
> https://www.postgresql.org/message-id/9434.1568839177@sss.pgh.pa.us 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