Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

Erwin Brandstetter <[email protected]> writes:
> Guess Tom's warning in
> https://www.postgresql.org/message-id/[email protected] 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