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: Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })

2023-09-27 Thread dld
On 27-09-2023 04:03, Erik Wienhold wrote: ccing list On 2023-09-27 00:12 +0200, dld write: On 26-09-2023 23:47, Erik Wienhold wrote: On 2023-09-26 14:44 +0200, dld wrote: I followed the discussion about the schema resolution, and I really think there is need for an early bound (at function

Early binding of CURRENT_SCHEMA (Was: CREATE FUNCTION ... SEARCH {, DEFAULT | SYSTEM | SESSION })

2023-09-26 Thread dld
Hi there! I followed the discussion about the schema resolution, and I really think there is need for an early bound (at function definition time) version of CURRENT_SCHEMA (the first member of search_path) Avoiding hard-coding of schema names, (and avoiding polluting the actual users schema