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
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
On Tuesday, October 15, 2024, Steve Lau wrote:
>
> 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 in
Steve Lau writes:
> 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 t
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
On Wed, 2024-10-16 at 04:00 +, 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
