3 ms·
Normally can't use an index as every value has to be coalesced before comparison.
by SigmundA 7y ago
Normally can't use an index as every value has to be coalesced before comparison.
- danaliv 7y agoYou 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.