Index of expression over table row or column

From: Steve Lau <stevelauc(at)outlook(dot)com>
To: "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>
Subject: Index of expression over table row or column
Date: 2024-10-16 03:07:15
Message-ID: 964FED20-AC2E-47C5-86FB-95C356A68B81@outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi, folks!

I am reading this documentation[1], and it has a sentence that I don’t quite understand: "The index columns (key values) can be either simple columns of the underlying table or expressions over the table rows.”, I am thinking that for the index of expressions, aren’t those expressions over table column? e.g., “CREATE INDEX idx_lower_last_name ON users(LOWER(last_name))”, “last_name" is a column rather than a row.

[1] https://www.postgresql.org/docs/17/index-api.html#INDEX-API

Regards, Steve.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2024-10-16 03:21:15 Re: Index of expression over table row or column
Previous Message PG Doc comments form 2024-10-15 10:31:23 CLUSTER command