Re: Index of expression over table row or column

2024-10-15 Thread Steve Lau
Hi > On Oct 16, 2024, at 12:17 PM, Laurenz Albe wrote: > > And what would you say about this (silly) example: > > CREATE TABLE x (a integer, b integer); > CREATE INDEX ON x(hash_record(x)); When I talk about an expression over something, I mainly think about it at the AST level, I guess the

Index of expression over table row or column

2024-10-15 Thread Steve Lau
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 expression

Re: Index of expression over table row or column

2024-10-15 Thread Steve Lau
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