Re: Indexing fragments of a column's value ?

2023-11-14 Thread dld
You can index on expressions, and these will be recognised by the query generator. drop schema tmp CASCADE; create schema tmp; set search_path = tmp; CREATE TABLE bagger     ( eight CHAR(8) NOT NULL PRIMARY KEY     , more text     ); CREATE INDEX bagger_idx_12 ON bagger (substr(e

Re: Issue in compiling postgres on latest macOS 14.1.1

2023-11-14 Thread Shaik Mohammad Mujeeb
Hi Team, As said by Tom Lane, I had some outdated binaries in my PATH. After removing those outdated binaries from the PATH, I didn't face any errors in postgres compilation. Thank you so much for all your assistance. Regards, Mujeeb. On Tue, Nov 14, 2023 at 1:29 AM Alban Hertroys wrote: > >