3 ms·
You can index the results of functions (or other expressions) in at least some databases. PostgreSQL can do this, for example. CREATE INDEX idx ON tbl (coale
by danaliv 7y ago
You can index the results of functions (or other expressions) in at least some databases. PostgreSQL can do this, for example.
CREATE INDEX idx ON tbl (coalesce(col, ''))
Combining this with UNIQUE can make for some neat tricks.