Re: Index of expression over table row or column

On Wed, 2024-10-16 at 04:00 +0000, Steve Lau wrote:

> Regarding Tom’s reply, IMHO, “LOWER(last_name || ' ' || first_name)” is still an
> expression over table columns? Would you like to elaborate on it a bit?

Well, a table row consists of columns.  So something that depends on or uses several
columns can be said to be "on the table row".  I'd say that the documentation is
correct, but if it gives you trouble, perhaps it should be improved.

And what would you say about this (silly) example:

  CREATE TABLE x (a integer, b integer);
  CREATE INDEX ON x(hash_record(x));

Yours,
Laurenz Albe