Re: Index of expression over table row or column

From: Steve Lau <stevelauc(at)outlook(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "david(dot)g(dot)johnston(at)gmail(dot)com" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Index of expression over table row or column
Date: 2024-10-16 04:00:17
Message-ID: FA21AE90-C2BC-40AD-8906-C646CA2EAE98@outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hi, thanks both for the reply.

> The description for pg_index.indkey uses the phrasing “an expression over the table columns” and this should be made to match.

Thanks David for showing me that existing documentation, I agree we should make them match.

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?

Regards, Steve.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2024-10-16 04:17:01 Re: Index of expression over table row or column
Previous Message Tom Lane 2024-10-16 03:23:08 Re: Index of expression over table row or column