| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Steve Lau <stevelauc(at)outlook(dot)com>, 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:17:01 |
| Message-ID: | fb83431b59299474a44353f70f552c7fd34e73f7.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Lau | 2024-10-16 06:14:25 | Re: Index of expression over table row or column |
| Previous Message | Steve Lau | 2024-10-16 04:00:17 | Re: Index of expression over table row or column |