Revision 2865
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 426 | 426 |
-- Name: _nullIf_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 427 | 427 |
-- |
| 428 | 428 |
|
| 429 |
CREATE UNIQUE INDEX "_nullIf_unique" ON "_nullIf" USING btree ("null", type, ensure_not_null(value));
|
|
| 429 |
CREATE UNIQUE INDEX "_nullIf_unique" ON "_nullIf" USING btree ("null", type, (COALESCE(value, '\\N'::text)));
|
|
| 430 | 430 |
|
| 431 | 431 |
|
| 432 | 432 |
-- |
Also available in: Unified diff
schemas/functions.sql: _nullIf: Changed indexes to use `COALESCE` to match what sql_gen now does