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
