Revision 3277
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 273 | 273 |
|
| 274 | 274 |
|
| 275 | 275 |
-- |
| 276 |
-- Name: _alt_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 277 |
-- |
|
| 278 |
|
|
| 279 |
CREATE INDEX _alt_0 ON _alt USING btree ((COALESCE("0", '\\N'::text)));
|
|
| 280 |
|
|
| 281 |
|
|
| 282 |
-- |
|
| 283 |
-- Name: _alt_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 284 |
-- |
|
| 285 |
|
|
| 286 |
CREATE INDEX _alt_1 ON _alt USING btree ((COALESCE("1", '\\N'::text)));
|
|
| 287 |
|
|
| 288 |
|
|
| 289 |
-- |
|
| 290 |
-- Name: _alt_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 291 |
-- |
|
| 292 |
|
|
| 293 |
CREATE INDEX _alt_2 ON _alt USING btree ((COALESCE("2", '\\N'::text)));
|
|
| 294 |
|
|
| 295 |
|
|
| 296 |
-- |
|
| 297 |
-- Name: _alt_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 298 |
-- |
|
| 299 |
|
|
| 300 |
CREATE INDEX _alt_3 ON _alt USING btree ((COALESCE("3", '\\N'::text)));
|
|
| 301 |
|
|
| 302 |
|
|
| 303 |
-- |
|
| 304 |
-- Name: _alt_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 305 |
-- |
|
| 306 |
|
|
| 307 |
CREATE INDEX _alt_4 ON _alt USING btree ((COALESCE("4", '\\N'::text)));
|
|
| 308 |
|
|
| 309 |
|
|
| 310 |
-- |
|
| 311 |
-- Name: _alt_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 312 |
-- |
|
| 313 |
|
|
| 314 |
CREATE INDEX _alt_5 ON _alt USING btree ((COALESCE("5", '\\N'::text)));
|
|
| 315 |
|
|
| 316 |
|
|
| 317 |
-- |
|
| 318 |
-- Name: _alt_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 319 |
-- |
|
| 320 |
|
|
| 321 |
CREATE INDEX _alt_6 ON _alt USING btree ((COALESCE("6", '\\N'::text)));
|
|
| 322 |
|
|
| 323 |
|
|
| 324 |
-- |
|
| 325 |
-- Name: _alt_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 326 |
-- |
|
| 327 |
|
|
| 328 |
CREATE INDEX _alt_7 ON _alt USING btree ((COALESCE("7", '\\N'::text)));
|
|
| 329 |
|
|
| 330 |
|
|
| 331 |
-- |
|
| 332 |
-- Name: _alt_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 333 |
-- |
|
| 334 |
|
|
| 335 |
CREATE INDEX _alt_8 ON _alt USING btree ((COALESCE("8", '\\N'::text)));
|
|
| 336 |
|
|
| 337 |
|
|
| 338 |
-- |
|
| 339 |
-- Name: _alt_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 340 |
-- |
|
| 341 |
|
|
| 342 |
CREATE INDEX _alt_9 ON _alt USING btree ((COALESCE("9", '\\N'::text)));
|
|
| 343 |
|
|
| 344 |
|
|
| 345 |
-- |
|
| 346 | 276 |
-- Name: _alt_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 347 | 277 |
-- |
| 348 | 278 |
|
| ... | ... | |
| 350 | 280 |
|
| 351 | 281 |
|
| 352 | 282 |
-- |
| 353 |
-- Name: _label_label; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 354 |
-- |
|
| 355 |
|
|
| 356 |
CREATE INDEX _label_label ON _label USING btree ((COALESCE(label, '\\N'::text))); |
|
| 357 |
|
|
| 358 |
|
|
| 359 |
-- |
|
| 360 | 283 |
-- Name: _label_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 361 | 284 |
-- |
| 362 | 285 |
|
| ... | ... | |
| 364 | 287 |
|
| 365 | 288 |
|
| 366 | 289 |
-- |
| 367 |
-- Name: _label_value; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 368 |
-- |
|
| 369 |
|
|
| 370 |
CREATE INDEX _label_value ON _label USING btree (value); |
|
| 371 |
|
|
| 372 |
|
|
| 373 |
-- |
|
| 374 |
-- Name: _merge_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 375 |
-- |
|
| 376 |
|
|
| 377 |
CREATE INDEX _merge_0 ON _merge USING btree ((COALESCE("0", '\\N'::text)));
|
|
| 378 |
|
|
| 379 |
|
|
| 380 |
-- |
|
| 381 |
-- Name: _merge_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 382 |
-- |
|
| 383 |
|
|
| 384 |
CREATE INDEX _merge_1 ON _merge USING btree ((COALESCE("1", '\\N'::text)));
|
|
| 385 |
|
|
| 386 |
|
|
| 387 |
-- |
|
| 388 |
-- Name: _merge_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 389 |
-- |
|
| 390 |
|
|
| 391 |
CREATE INDEX _merge_2 ON _merge USING btree ((COALESCE("2", '\\N'::text)));
|
|
| 392 |
|
|
| 393 |
|
|
| 394 |
-- |
|
| 395 |
-- Name: _merge_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 396 |
-- |
|
| 397 |
|
|
| 398 |
CREATE INDEX _merge_3 ON _merge USING btree ((COALESCE("3", '\\N'::text)));
|
|
| 399 |
|
|
| 400 |
|
|
| 401 |
-- |
|
| 402 |
-- Name: _merge_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 403 |
-- |
|
| 404 |
|
|
| 405 |
CREATE INDEX _merge_4 ON _merge USING btree ((COALESCE("4", '\\N'::text)));
|
|
| 406 |
|
|
| 407 |
|
|
| 408 |
-- |
|
| 409 |
-- Name: _merge_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 410 |
-- |
|
| 411 |
|
|
| 412 |
CREATE INDEX _merge_5 ON _merge USING btree ((COALESCE("5", '\\N'::text)));
|
|
| 413 |
|
|
| 414 |
|
|
| 415 |
-- |
|
| 416 |
-- Name: _merge_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 417 |
-- |
|
| 418 |
|
|
| 419 |
CREATE INDEX _merge_6 ON _merge USING btree ((COALESCE("6", '\\N'::text)));
|
|
| 420 |
|
|
| 421 |
|
|
| 422 |
-- |
|
| 423 |
-- Name: _merge_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 424 |
-- |
|
| 425 |
|
|
| 426 |
CREATE INDEX _merge_7 ON _merge USING btree ((COALESCE("7", '\\N'::text)));
|
|
| 427 |
|
|
| 428 |
|
|
| 429 |
-- |
|
| 430 |
-- Name: _merge_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 431 |
-- |
|
| 432 |
|
|
| 433 |
CREATE INDEX _merge_8 ON _merge USING btree ((COALESCE("8", '\\N'::text)));
|
|
| 434 |
|
|
| 435 |
|
|
| 436 |
-- |
|
| 437 |
-- Name: _merge_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 438 |
-- |
|
| 439 |
|
|
| 440 |
CREATE INDEX _merge_9 ON _merge USING btree ((COALESCE("9", '\\N'::text)));
|
|
| 441 |
|
|
| 442 |
|
|
| 443 |
-- |
|
| 444 | 290 |
-- Name: _merge_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 445 | 291 |
-- |
| 446 | 292 |
|
| ... | ... | |
| 448 | 294 |
|
| 449 | 295 |
|
| 450 | 296 |
-- |
| 451 |
-- Name: _nullIf_null; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 452 |
-- |
|
| 453 |
|
|
| 454 |
CREATE INDEX "_nullIf_null" ON "_nullIf" USING btree ("null");
|
|
| 455 |
|
|
| 456 |
|
|
| 457 |
-- |
|
| 458 |
-- Name: _nullIf_type; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 459 |
-- |
|
| 460 |
|
|
| 461 |
CREATE INDEX "_nullIf_type" ON "_nullIf" USING btree (type); |
|
| 462 |
|
|
| 463 |
|
|
| 464 |
-- |
|
| 465 | 297 |
-- Name: _nullIf_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 466 | 298 |
-- |
| 467 | 299 |
|
| ... | ... | |
| 469 | 301 |
|
| 470 | 302 |
|
| 471 | 303 |
-- |
| 472 |
-- Name: _nullIf_value; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
|
| 473 |
-- |
|
| 474 |
|
|
| 475 |
CREATE INDEX "_nullIf_value" ON "_nullIf" USING btree (value); |
|
| 476 |
|
|
| 477 |
|
|
| 478 |
-- |
|
| 479 | 304 |
-- Name: _alt; Type: TRIGGER; Schema: functions; Owner: - |
| 480 | 305 |
-- |
| 481 | 306 |
|
Also available in: Unified diff
schemas/functions.sql: Removed per-column indexes on relational functions, which are no longer needed by row-based import because it is able to do a merge join-style lookup using the table's UNIQUE INDEX. (Note that column-based import doesn't use the (slower) relational functions at all anymore, and instead calls the corresponding SQL function directly using named arguments.)