Values of type spoint can be indexed using a
HASH index, supporting the
= operator.
The spoint_hash_ops operator class also enables
DISTINCT queries on spoint.
Example 7.3. Hash index of spoints
CREATE TABLE sky (
star spoint
);
CREATE INDEX ON sky USING HASH (star);
SELECT DISTINCT star FROM sky;