288 |
288 |
|
289 |
289 |
|
290 |
290 |
--
|
|
291 |
-- Name: _alt_0; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
292 |
--
|
|
293 |
|
|
294 |
CREATE INDEX _alt_0 ON _alt USING btree ("0");
|
|
295 |
|
|
296 |
|
|
297 |
--
|
|
298 |
-- Name: _alt_1; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
299 |
--
|
|
300 |
|
|
301 |
CREATE INDEX _alt_1 ON _alt USING btree ("1");
|
|
302 |
|
|
303 |
|
|
304 |
--
|
|
305 |
-- Name: _alt_2; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
306 |
--
|
|
307 |
|
|
308 |
CREATE INDEX _alt_2 ON _alt USING btree ("2");
|
|
309 |
|
|
310 |
|
|
311 |
--
|
|
312 |
-- Name: _alt_3; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
313 |
--
|
|
314 |
|
|
315 |
CREATE INDEX _alt_3 ON _alt USING btree ("3");
|
|
316 |
|
|
317 |
|
|
318 |
--
|
|
319 |
-- Name: _alt_4; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
320 |
--
|
|
321 |
|
|
322 |
CREATE INDEX _alt_4 ON _alt USING btree ("4");
|
|
323 |
|
|
324 |
|
|
325 |
--
|
|
326 |
-- Name: _alt_5; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
327 |
--
|
|
328 |
|
|
329 |
CREATE INDEX _alt_5 ON _alt USING btree ("5");
|
|
330 |
|
|
331 |
|
|
332 |
--
|
|
333 |
-- Name: _alt_6; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
334 |
--
|
|
335 |
|
|
336 |
CREATE INDEX _alt_6 ON _alt USING btree ("6");
|
|
337 |
|
|
338 |
|
|
339 |
--
|
|
340 |
-- Name: _alt_7; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
341 |
--
|
|
342 |
|
|
343 |
CREATE INDEX _alt_7 ON _alt USING btree ("7");
|
|
344 |
|
|
345 |
|
|
346 |
--
|
|
347 |
-- Name: _alt_8; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
348 |
--
|
|
349 |
|
|
350 |
CREATE INDEX _alt_8 ON _alt USING btree ("8");
|
|
351 |
|
|
352 |
|
|
353 |
--
|
|
354 |
-- Name: _alt_9; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
355 |
--
|
|
356 |
|
|
357 |
CREATE INDEX _alt_9 ON _alt USING btree ("9");
|
|
358 |
|
|
359 |
|
|
360 |
--
|
291 |
361 |
-- Name: _alt_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
292 |
362 |
--
|
293 |
363 |
|
... | ... | |
295 |
365 |
|
296 |
366 |
|
297 |
367 |
--
|
|
368 |
-- Name: _label_label; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
369 |
--
|
|
370 |
|
|
371 |
CREATE INDEX _label_label ON _label USING btree (label);
|
|
372 |
|
|
373 |
|
|
374 |
--
|
298 |
375 |
-- Name: _label_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
299 |
376 |
--
|
300 |
377 |
|
... | ... | |
302 |
379 |
|
303 |
380 |
|
304 |
381 |
--
|
|
382 |
-- Name: _label_value; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
383 |
--
|
|
384 |
|
|
385 |
CREATE INDEX _label_value ON _label USING btree (value);
|
|
386 |
|
|
387 |
|
|
388 |
--
|
|
389 |
-- Name: _merge_0; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
390 |
--
|
|
391 |
|
|
392 |
CREATE INDEX _merge_0 ON _merge USING btree ("0");
|
|
393 |
|
|
394 |
|
|
395 |
--
|
|
396 |
-- Name: _merge_1; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
397 |
--
|
|
398 |
|
|
399 |
CREATE INDEX _merge_1 ON _merge USING btree ("1");
|
|
400 |
|
|
401 |
|
|
402 |
--
|
|
403 |
-- Name: _merge_2; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
404 |
--
|
|
405 |
|
|
406 |
CREATE INDEX _merge_2 ON _merge USING btree ("2");
|
|
407 |
|
|
408 |
|
|
409 |
--
|
|
410 |
-- Name: _merge_3; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
411 |
--
|
|
412 |
|
|
413 |
CREATE INDEX _merge_3 ON _merge USING btree ("3");
|
|
414 |
|
|
415 |
|
|
416 |
--
|
|
417 |
-- Name: _merge_4; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
418 |
--
|
|
419 |
|
|
420 |
CREATE INDEX _merge_4 ON _merge USING btree ("4");
|
|
421 |
|
|
422 |
|
|
423 |
--
|
|
424 |
-- Name: _merge_5; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
425 |
--
|
|
426 |
|
|
427 |
CREATE INDEX _merge_5 ON _merge USING btree ("5");
|
|
428 |
|
|
429 |
|
|
430 |
--
|
|
431 |
-- Name: _merge_6; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
432 |
--
|
|
433 |
|
|
434 |
CREATE INDEX _merge_6 ON _merge USING btree ("6");
|
|
435 |
|
|
436 |
|
|
437 |
--
|
|
438 |
-- Name: _merge_7; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
439 |
--
|
|
440 |
|
|
441 |
CREATE INDEX _merge_7 ON _merge USING btree ("7");
|
|
442 |
|
|
443 |
|
|
444 |
--
|
|
445 |
-- Name: _merge_8; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
446 |
--
|
|
447 |
|
|
448 |
CREATE INDEX _merge_8 ON _merge USING btree ("8");
|
|
449 |
|
|
450 |
|
|
451 |
--
|
|
452 |
-- Name: _merge_9; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
453 |
--
|
|
454 |
|
|
455 |
CREATE INDEX _merge_9 ON _merge USING btree ("9");
|
|
456 |
|
|
457 |
|
|
458 |
--
|
305 |
459 |
-- Name: _merge_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
306 |
460 |
--
|
307 |
461 |
|
... | ... | |
309 |
463 |
|
310 |
464 |
|
311 |
465 |
--
|
|
466 |
-- Name: _nullIf_null; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
467 |
--
|
|
468 |
|
|
469 |
CREATE INDEX "_nullIf_null" ON "_nullIf" USING btree ("null");
|
|
470 |
|
|
471 |
|
|
472 |
--
|
|
473 |
-- Name: _nullIf_type; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
474 |
--
|
|
475 |
|
|
476 |
CREATE INDEX "_nullIf_type" ON "_nullIf" USING btree (type);
|
|
477 |
|
|
478 |
|
|
479 |
--
|
312 |
480 |
-- Name: _nullIf_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
313 |
481 |
--
|
314 |
482 |
|
... | ... | |
316 |
484 |
|
317 |
485 |
|
318 |
486 |
--
|
|
487 |
-- Name: _nullIf_value; Type: INDEX; Schema: functions; Owner: -; Tablespace:
|
|
488 |
--
|
|
489 |
|
|
490 |
CREATE INDEX "_nullIf_value" ON "_nullIf" USING btree (value);
|
|
491 |
|
|
492 |
|
|
493 |
--
|
319 |
494 |
-- Name: _alt; Type: TRIGGER; Schema: functions; Owner: -
|
320 |
495 |
--
|
321 |
496 |
|
schemas/functions.sql: Added indexes on all relational function parameters since the unique index will not be used for lookups