7.3. Hash index
Prev | Up | Chapter 7. Indexes | Home | Next

## 7.3. Hash index #

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;

Prev | Up | Next
7.2. `smoc` index | Home | Chapter 8. Examples