Index of expression over table row or column - Mailing list pgsql-docs

From Steve Lau
Subject Index of expression over table row or column
Date
Msg-id 964FED20-AC2E-47C5-86FB-95C356A68B81@outlook.com
Whole thread Raw
Responses Re: Index of expression over table row or column
Re: Index of expression over table row or column
List 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.



Regards, Steve.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: CLUSTER command
Next
From: "David G. Johnston"
Date:
Subject: Re: Index of expression over table row or column