Revision 2839
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 335 | 335 |
-- Name: _merge_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 336 | 336 |
-- |
| 337 | 337 |
|
| 338 |
CREATE INDEX _merge_0 ON _merge USING btree ("0");
|
|
| 338 |
CREATE INDEX _merge_0 ON _merge USING btree ((COALESCE("0", '\\N'::text)));
|
|
| 339 | 339 |
|
| 340 | 340 |
|
| 341 | 341 |
-- |
| 342 | 342 |
-- Name: _merge_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 343 | 343 |
-- |
| 344 | 344 |
|
| 345 |
CREATE INDEX _merge_1 ON _merge USING btree ("1");
|
|
| 345 |
CREATE INDEX _merge_1 ON _merge USING btree ((COALESCE("1", '\\N'::text)));
|
|
| 346 | 346 |
|
| 347 | 347 |
|
| 348 | 348 |
-- |
| 349 | 349 |
-- Name: _merge_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 350 | 350 |
-- |
| 351 | 351 |
|
| 352 |
CREATE INDEX _merge_2 ON _merge USING btree ("2");
|
|
| 352 |
CREATE INDEX _merge_2 ON _merge USING btree ((COALESCE("2", '\\N'::text)));
|
|
| 353 | 353 |
|
| 354 | 354 |
|
| 355 | 355 |
-- |
| 356 | 356 |
-- Name: _merge_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 357 | 357 |
-- |
| 358 | 358 |
|
| 359 |
CREATE INDEX _merge_3 ON _merge USING btree ("3");
|
|
| 359 |
CREATE INDEX _merge_3 ON _merge USING btree ((COALESCE("3", '\\N'::text)));
|
|
| 360 | 360 |
|
| 361 | 361 |
|
| 362 | 362 |
-- |
| 363 | 363 |
-- Name: _merge_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 364 | 364 |
-- |
| 365 | 365 |
|
| 366 |
CREATE INDEX _merge_4 ON _merge USING btree ("4");
|
|
| 366 |
CREATE INDEX _merge_4 ON _merge USING btree ((COALESCE("4", '\\N'::text)));
|
|
| 367 | 367 |
|
| 368 | 368 |
|
| 369 | 369 |
-- |
| 370 | 370 |
-- Name: _merge_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 371 | 371 |
-- |
| 372 | 372 |
|
| 373 |
CREATE INDEX _merge_5 ON _merge USING btree ("5");
|
|
| 373 |
CREATE INDEX _merge_5 ON _merge USING btree ((COALESCE("5", '\\N'::text)));
|
|
| 374 | 374 |
|
| 375 | 375 |
|
| 376 | 376 |
-- |
| 377 | 377 |
-- Name: _merge_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 378 | 378 |
-- |
| 379 | 379 |
|
| 380 |
CREATE INDEX _merge_6 ON _merge USING btree ("6");
|
|
| 380 |
CREATE INDEX _merge_6 ON _merge USING btree ((COALESCE("6", '\\N'::text)));
|
|
| 381 | 381 |
|
| 382 | 382 |
|
| 383 | 383 |
-- |
| 384 | 384 |
-- Name: _merge_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 385 | 385 |
-- |
| 386 | 386 |
|
| 387 |
CREATE INDEX _merge_7 ON _merge USING btree ("7");
|
|
| 387 |
CREATE INDEX _merge_7 ON _merge USING btree ((COALESCE("7", '\\N'::text)));
|
|
| 388 | 388 |
|
| 389 | 389 |
|
| 390 | 390 |
-- |
| 391 | 391 |
-- Name: _merge_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 392 | 392 |
-- |
| 393 | 393 |
|
| 394 |
CREATE INDEX _merge_8 ON _merge USING btree ("8");
|
|
| 394 |
CREATE INDEX _merge_8 ON _merge USING btree ((COALESCE("8", '\\N'::text)));
|
|
| 395 | 395 |
|
| 396 | 396 |
|
| 397 | 397 |
-- |
| 398 | 398 |
-- Name: _merge_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 399 | 399 |
-- |
| 400 | 400 |
|
| 401 |
CREATE INDEX _merge_9 ON _merge USING btree ("9");
|
|
| 401 |
CREATE INDEX _merge_9 ON _merge USING btree ((COALESCE("9", '\\N'::text)));
|
|
| 402 | 402 |
|
| 403 | 403 |
|
| 404 | 404 |
-- |
| 405 | 405 |
-- Name: _merge_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 406 | 406 |
-- |
| 407 | 407 |
|
| 408 |
CREATE UNIQUE INDEX _merge_unique ON _merge USING btree (ensure_not_null("0"), ensure_not_null("1"), ensure_not_null("2"), ensure_not_null("3"), ensure_not_null("4"), ensure_not_null("5"), ensure_not_null("6"), ensure_not_null("7"), ensure_not_null("8"), ensure_not_null("9"));
|
|
| 408 |
CREATE UNIQUE INDEX _merge_unique ON _merge USING btree ((COALESCE("0", '\\N'::text)), (COALESCE("1", '\\N'::text)), (COALESCE("2", '\\N'::text)), (COALESCE("3", '\\N'::text)), (COALESCE("4", '\\N'::text)), (COALESCE("5", '\\N'::text)), (COALESCE("6", '\\N'::text)), (COALESCE("7", '\\N'::text)), (COALESCE("8", '\\N'::text)), (COALESCE("9", '\\N'::text)));
|
|
| 409 | 409 |
|
| 410 | 410 |
|
| 411 | 411 |
-- |
Also available in: Unified diff
schemas/functions.sql: _merge: Changed indexes to use `COALESCE` to match what sql_gen now does