| 452 |
452 |
SET search_path = public_validations, pg_catalog;
|
| 453 |
453 |
|
| 454 |
454 |
--
|
|
455 |
-- Name: keys_~type._plots_01_count_of_projects; Type: TYPE; Schema: public_validations; Owner: -
|
|
456 |
--
|
|
457 |
|
|
458 |
CREATE TYPE "keys_~type._plots_01_count_of_projects" AS (
|
|
459 |
);
|
|
460 |
|
|
461 |
|
|
462 |
--
|
|
463 |
-- Name: keys_~type._plots_02_list_of_project_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
464 |
--
|
|
465 |
|
|
466 |
CREATE TYPE "keys_~type._plots_02_list_of_project_names" AS (
|
|
467 |
project_name text
|
|
468 |
);
|
|
469 |
|
|
470 |
|
|
471 |
--
|
|
472 |
-- Name: keys_~type._plots_03_count_of_all_plots_in_this_source; Type: TYPE; Schema: public_validations; Owner: -
|
|
473 |
--
|
|
474 |
|
|
475 |
CREATE TYPE "keys_~type._plots_03_count_of_all_plots_in_this_source" AS (
|
|
476 |
);
|
|
477 |
|
|
478 |
|
|
479 |
--
|
|
480 |
-- Name: keys_~type._plots_04_count_of_plots_in_each_project_in_this_sou; Type: TYPE; Schema: public_validations; Owner: -
|
|
481 |
--
|
|
482 |
|
|
483 |
CREATE TYPE "keys_~type._plots_04_count_of_plots_in_each_project_in_this_sou" AS (
|
|
484 |
project_name text
|
|
485 |
);
|
|
486 |
|
|
487 |
|
|
488 |
--
|
|
489 |
-- Name: keys_~type._plots_05_list_of_plot_codes_by_project; Type: TYPE; Schema: public_validations; Owner: -
|
|
490 |
--
|
|
491 |
|
|
492 |
CREATE TYPE "keys_~type._plots_05_list_of_plot_codes_by_project" AS (
|
|
493 |
project_name text,
|
|
494 |
plot_code text
|
|
495 |
);
|
|
496 |
|
|
497 |
|
|
498 |
--
|
|
499 |
-- Name: keys_~type._plots_06_list_of_plots_with_stem_measurements; Type: TYPE; Schema: public_validations; Owner: -
|
|
500 |
--
|
|
501 |
|
|
502 |
CREATE TYPE "keys_~type._plots_06_list_of_plots_with_stem_measurements" AS (
|
|
503 |
project_name text,
|
|
504 |
plot_code text
|
|
505 |
);
|
|
506 |
|
|
507 |
|
|
508 |
--
|
|
509 |
-- Name: keys_~type._plots_10_count_of_individuals_per_plot_in_each_proj; Type: TYPE; Schema: public_validations; Owner: -
|
|
510 |
--
|
|
511 |
|
|
512 |
CREATE TYPE "keys_~type._plots_10_count_of_individuals_per_plot_in_each_proj" AS (
|
|
513 |
project_name text,
|
|
514 |
plot_code text
|
|
515 |
);
|
|
516 |
|
|
517 |
|
|
518 |
--
|
|
519 |
-- Name: keys_~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: -
|
|
520 |
--
|
|
521 |
|
|
522 |
CREATE TYPE "keys_~type._plots_11_count_of_stems_per_plot_in_each_project" AS (
|
|
523 |
project_name text,
|
|
524 |
plot_code text
|
|
525 |
);
|
|
526 |
|
|
527 |
|
|
528 |
--
|
|
529 |
-- Name: keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_pr; Type: TYPE; Schema: public_validations; Owner: -
|
|
530 |
--
|
|
531 |
|
|
532 |
CREATE TYPE "keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_pr" AS (
|
|
533 |
project_name text,
|
|
534 |
plot_code text
|
|
535 |
);
|
|
536 |
|
|
537 |
|
|
538 |
--
|
|
539 |
-- Name: keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plo; Type: TYPE; Schema: public_validations; Owner: -
|
|
540 |
--
|
|
541 |
|
|
542 |
CREATE TYPE "keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plo" AS (
|
|
543 |
project_name text,
|
|
544 |
plot_code text,
|
|
545 |
taxon text
|
|
546 |
);
|
|
547 |
|
|
548 |
|
|
549 |
--
|
|
550 |
-- Name: keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot; Type: TYPE; Schema: public_validations; Owner: -
|
|
551 |
--
|
|
552 |
|
|
553 |
CREATE TYPE "keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot" AS (
|
|
554 |
project_name text,
|
|
555 |
plot_code text,
|
|
556 |
taxon text
|
|
557 |
);
|
|
558 |
|
|
559 |
|
|
560 |
--
|
|
561 |
-- Name: keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec; Type: TYPE; Schema: public_validations; Owner: -
|
|
562 |
--
|
|
563 |
|
|
564 |
CREATE TYPE "keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec" AS (
|
|
565 |
project_name text,
|
|
566 |
plot_code text
|
|
567 |
);
|
|
568 |
|
|
569 |
|
|
570 |
--
|
|
571 |
-- Name: keys_~type._traits_02_count_trait_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
572 |
--
|
|
573 |
|
|
574 |
CREATE TYPE "keys_~type._traits_02_count_trait_names" AS (
|
|
575 |
);
|
|
576 |
|
|
577 |
|
|
578 |
--
|
|
579 |
-- Name: keys_~type._traits_03_list_trait_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
580 |
--
|
|
581 |
|
|
582 |
CREATE TYPE "keys_~type._traits_03_list_trait_names" AS (
|
|
583 |
trait text
|
|
584 |
);
|
|
585 |
|
|
586 |
|
|
587 |
--
|
|
588 |
-- Name: keys_~type._traits_04_count_records_per_trait; Type: TYPE; Schema: public_validations; Owner: -
|
|
589 |
--
|
|
590 |
|
|
591 |
CREATE TYPE "keys_~type._traits_04_count_records_per_trait" AS (
|
|
592 |
trait text
|
|
593 |
);
|
|
594 |
|
|
595 |
|
|
596 |
--
|
|
597 |
-- Name: keys_~type._traits_05_count_taxa; Type: TYPE; Schema: public_validations; Owner: -
|
|
598 |
--
|
|
599 |
|
|
600 |
CREATE TYPE "keys_~type._traits_05_count_taxa" AS (
|
|
601 |
);
|
|
602 |
|
|
603 |
|
|
604 |
--
|
|
605 |
-- Name: keys_~type._traits_06_list_distinct_taxa; Type: TYPE; Schema: public_validations; Owner: -
|
|
606 |
--
|
|
607 |
|
|
608 |
CREATE TYPE "keys_~type._traits_06_list_distinct_taxa" AS (
|
|
609 |
taxonwithauthor text
|
|
610 |
);
|
|
611 |
|
|
612 |
|
|
613 |
--
|
|
614 |
-- Name: keys_~type._traits_07_trait_value_and_units; Type: TYPE; Schema: public_validations; Owner: -
|
|
615 |
--
|
|
616 |
|
|
617 |
CREATE TYPE "keys_~type._traits_07_trait_value_and_units" AS (
|
|
618 |
trait text,
|
|
619 |
value text,
|
|
620 |
units text
|
|
621 |
);
|
|
622 |
|
|
623 |
|
|
624 |
--
|
|
625 |
-- Name: keys_~type._traits_08_taxonname_trait_and_value; Type: TYPE; Schema: public_validations; Owner: -
|
|
626 |
--
|
|
627 |
|
|
628 |
CREATE TYPE "keys_~type._traits_08_taxonname_trait_and_value" AS (
|
|
629 |
taxonwithauthor text,
|
|
630 |
trait text,
|
|
631 |
value text
|
|
632 |
);
|
|
633 |
|
|
634 |
|
|
635 |
--
|
| 455 |
636 |
-- Name: schema_anchor; Type: TYPE; Schema: public_validations; Owner: -
|
| 456 |
637 |
--
|
| 457 |
638 |
|
| ... | ... | |
| 466 |
647 |
COMMENT ON TYPE schema_anchor IS 'used with schema_anchor params';
|
| 467 |
648 |
|
| 468 |
649 |
|
|
650 |
--
|
|
651 |
-- Name: values__~type._plots_01_count_of_projects; Type: TYPE; Schema: public_validations; Owner: -
|
|
652 |
--
|
|
653 |
|
|
654 |
CREATE TYPE "values__~type._plots_01_count_of_projects" AS (
|
|
655 |
projects bigint
|
|
656 |
);
|
|
657 |
|
|
658 |
|
|
659 |
--
|
|
660 |
-- Name: values__~type._plots_02_list_of_project_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
661 |
--
|
|
662 |
|
|
663 |
CREATE TYPE "values__~type._plots_02_list_of_project_names" AS (
|
|
664 |
project_name text
|
|
665 |
);
|
|
666 |
|
|
667 |
|
|
668 |
--
|
|
669 |
-- Name: values__~type._plots_03_count_of_all_plots_in_this_source; Type: TYPE; Schema: public_validations; Owner: -
|
|
670 |
--
|
|
671 |
|
|
672 |
CREATE TYPE "values__~type._plots_03_count_of_all_plots_in_this_source" AS (
|
|
673 |
plots bigint
|
|
674 |
);
|
|
675 |
|
|
676 |
|
|
677 |
--
|
|
678 |
-- Name: values__~type._plots_04_count_of_plots_in_each_project_in_this_; Type: TYPE; Schema: public_validations; Owner: -
|
|
679 |
--
|
|
680 |
|
|
681 |
CREATE TYPE "values__~type._plots_04_count_of_plots_in_each_project_in_this_" AS (
|
|
682 |
plots bigint
|
|
683 |
);
|
|
684 |
|
|
685 |
|
|
686 |
--
|
|
687 |
-- Name: values__~type._plots_05_list_of_plot_codes_by_project; Type: TYPE; Schema: public_validations; Owner: -
|
|
688 |
--
|
|
689 |
|
|
690 |
CREATE TYPE "values__~type._plots_05_list_of_plot_codes_by_project" AS (
|
|
691 |
project_name text,
|
|
692 |
plot_code text
|
|
693 |
);
|
|
694 |
|
|
695 |
|
|
696 |
--
|
|
697 |
-- Name: values__~type._plots_06_list_of_plots_with_stem_measurements; Type: TYPE; Schema: public_validations; Owner: -
|
|
698 |
--
|
|
699 |
|
|
700 |
CREATE TYPE "values__~type._plots_06_list_of_plots_with_stem_measurements" AS (
|
|
701 |
project_name text,
|
|
702 |
plot_code text
|
|
703 |
);
|
|
704 |
|
|
705 |
|
|
706 |
--
|
|
707 |
-- Name: values__~type._plots_10_count_of_individuals_per_plot_in_each_p; Type: TYPE; Schema: public_validations; Owner: -
|
|
708 |
--
|
|
709 |
|
|
710 |
CREATE TYPE "values__~type._plots_10_count_of_individuals_per_plot_in_each_p" AS (
|
|
711 |
individuals bigint
|
|
712 |
);
|
|
713 |
|
|
714 |
|
|
715 |
--
|
|
716 |
-- Name: values__~type._plots_11_count_of_stems_per_plot_in_each_project; Type: TYPE; Schema: public_validations; Owner: -
|
|
717 |
--
|
|
718 |
|
|
719 |
CREATE TYPE "values__~type._plots_11_count_of_stems_per_plot_in_each_project" AS (
|
|
720 |
stems bigint
|
|
721 |
);
|
|
722 |
|
|
723 |
|
|
724 |
--
|
|
725 |
-- Name: values__~type._plots_12_count_of_verbatim_taxa_per_plot_in_each; Type: TYPE; Schema: public_validations; Owner: -
|
|
726 |
--
|
|
727 |
|
|
728 |
CREATE TYPE "values__~type._plots_12_count_of_verbatim_taxa_per_plot_in_each" AS (
|
|
729 |
taxa bigint
|
|
730 |
);
|
|
731 |
|
|
732 |
|
|
733 |
--
|
|
734 |
-- Name: values__~type._plots_13_list_of_distinct_verbatim_taxa_in_each_; Type: TYPE; Schema: public_validations; Owner: -
|
|
735 |
--
|
|
736 |
|
|
737 |
CREATE TYPE "values__~type._plots_13_list_of_distinct_verbatim_taxa_in_each_" AS (
|
|
738 |
project_name text,
|
|
739 |
plot_code text,
|
|
740 |
taxon text
|
|
741 |
);
|
|
742 |
|
|
743 |
|
|
744 |
--
|
|
745 |
-- Name: values__~type._plots_14_count_of_indiv_per_verbatim_taxon_per_p; Type: TYPE; Schema: public_validations; Owner: -
|
|
746 |
--
|
|
747 |
|
|
748 |
CREATE TYPE "values__~type._plots_14_count_of_indiv_per_verbatim_taxon_per_p" AS (
|
|
749 |
individuals bigint
|
|
750 |
);
|
|
751 |
|
|
752 |
|
|
753 |
--
|
|
754 |
-- Name: values__~type._plots_17_count_of_subplots_per_plot_for_each_pro; Type: TYPE; Schema: public_validations; Owner: -
|
|
755 |
--
|
|
756 |
|
|
757 |
CREATE TYPE "values__~type._plots_17_count_of_subplots_per_plot_for_each_pro" AS (
|
|
758 |
subplots bigint
|
|
759 |
);
|
|
760 |
|
|
761 |
|
|
762 |
--
|
|
763 |
-- Name: values__~type._traits_02_count_trait_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
764 |
--
|
|
765 |
|
|
766 |
CREATE TYPE "values__~type._traits_02_count_trait_names" AS (
|
|
767 |
traits bigint
|
|
768 |
);
|
|
769 |
|
|
770 |
|
|
771 |
--
|
|
772 |
-- Name: values__~type._traits_03_list_trait_names; Type: TYPE; Schema: public_validations; Owner: -
|
|
773 |
--
|
|
774 |
|
|
775 |
CREATE TYPE "values__~type._traits_03_list_trait_names" AS (
|
|
776 |
trait text
|
|
777 |
);
|
|
778 |
|
|
779 |
|
|
780 |
--
|
|
781 |
-- Name: values__~type._traits_04_count_records_per_trait; Type: TYPE; Schema: public_validations; Owner: -
|
|
782 |
--
|
|
783 |
|
|
784 |
CREATE TYPE "values__~type._traits_04_count_records_per_trait" AS (
|
|
785 |
measurements bigint
|
|
786 |
);
|
|
787 |
|
|
788 |
|
|
789 |
--
|
|
790 |
-- Name: values__~type._traits_05_count_taxa; Type: TYPE; Schema: public_validations; Owner: -
|
|
791 |
--
|
|
792 |
|
|
793 |
CREATE TYPE "values__~type._traits_05_count_taxa" AS (
|
|
794 |
taxa bigint
|
|
795 |
);
|
|
796 |
|
|
797 |
|
|
798 |
--
|
|
799 |
-- Name: values__~type._traits_06_list_distinct_taxa; Type: TYPE; Schema: public_validations; Owner: -
|
|
800 |
--
|
|
801 |
|
|
802 |
CREATE TYPE "values__~type._traits_06_list_distinct_taxa" AS (
|
|
803 |
taxonwithauthor text
|
|
804 |
);
|
|
805 |
|
|
806 |
|
|
807 |
--
|
|
808 |
-- Name: values__~type._traits_07_trait_value_and_units; Type: TYPE; Schema: public_validations; Owner: -
|
|
809 |
--
|
|
810 |
|
|
811 |
CREATE TYPE "values__~type._traits_07_trait_value_and_units" AS (
|
|
812 |
trait text,
|
|
813 |
value text,
|
|
814 |
units text
|
|
815 |
);
|
|
816 |
|
|
817 |
|
|
818 |
--
|
|
819 |
-- Name: values__~type._traits_08_taxonname_trait_and_value; Type: TYPE; Schema: public_validations; Owner: -
|
|
820 |
--
|
|
821 |
|
|
822 |
CREATE TYPE "values__~type._traits_08_taxonname_trait_and_value" AS (
|
|
823 |
taxonwithauthor text,
|
|
824 |
trait text,
|
|
825 |
value text
|
|
826 |
);
|
|
827 |
|
|
828 |
|
| 469 |
829 |
SET search_path = public, pg_catalog;
|
| 470 |
830 |
|
| 471 |
831 |
--
|
| ... | ... | |
| 1984 |
2344 |
-- Name: keys("~type._plots_01_count_of_projects"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 1985 |
2345 |
--
|
| 1986 |
2346 |
|
| 1987 |
|
CREATE FUNCTION keys(value "~type._plots_01_count_of_projects") RETURNS record
|
|
2347 |
CREATE FUNCTION keys(value "~type._plots_01_count_of_projects") RETURNS "keys_~type._plots_01_count_of_projects"
|
| 1988 |
2348 |
LANGUAGE sql IMMUTABLE
|
| 1989 |
2349 |
AS $$
|
| 1990 |
|
SELECT ROW()
|
|
2350 |
SELECT ROW()::public_validations."keys_~type._plots_01_count_of_projects"
|
| 1991 |
2351 |
$$;
|
| 1992 |
2352 |
|
| 1993 |
2353 |
|
| ... | ... | |
| 2004 |
2364 |
-- Name: keys("~type._plots_02_list_of_project_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2005 |
2365 |
--
|
| 2006 |
2366 |
|
| 2007 |
|
CREATE FUNCTION keys(value "~type._plots_02_list_of_project_names", OUT project_name text) RETURNS text
|
|
2367 |
CREATE FUNCTION keys(value "~type._plots_02_list_of_project_names") RETURNS "keys_~type._plots_02_list_of_project_names"
|
| 2008 |
2368 |
LANGUAGE sql IMMUTABLE
|
| 2009 |
2369 |
AS $_$
|
| 2010 |
|
SELECT ($1.project_name)
|
|
2370 |
SELECT ROW($1.project_name)::public_validations."keys_~type._plots_02_list_of_project_names"
|
| 2011 |
2371 |
$_$;
|
| 2012 |
2372 |
|
| 2013 |
2373 |
|
| ... | ... | |
| 2024 |
2384 |
-- Name: keys("~type._plots_03_count_of_all_plots_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2025 |
2385 |
--
|
| 2026 |
2386 |
|
| 2027 |
|
CREATE FUNCTION keys(value "~type._plots_03_count_of_all_plots_in_this_source") RETURNS record
|
|
2387 |
CREATE FUNCTION keys(value "~type._plots_03_count_of_all_plots_in_this_source") RETURNS "keys_~type._plots_03_count_of_all_plots_in_this_source"
|
| 2028 |
2388 |
LANGUAGE sql IMMUTABLE
|
| 2029 |
2389 |
AS $$
|
| 2030 |
|
SELECT ROW()
|
|
2390 |
SELECT ROW()::public_validations."keys_~type._plots_03_count_of_all_plots_in_this_source"
|
| 2031 |
2391 |
$$;
|
| 2032 |
2392 |
|
| 2033 |
2393 |
|
| ... | ... | |
| 2045 |
2405 |
-- Name: keys("~type._plots_04_count_of_plots_in_each_project_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2046 |
2406 |
--
|
| 2047 |
2407 |
|
| 2048 |
|
CREATE FUNCTION keys(value "~type._plots_04_count_of_plots_in_each_project_in_this_source", OUT project_name text) RETURNS text
|
|
2408 |
CREATE FUNCTION keys(value "~type._plots_04_count_of_plots_in_each_project_in_this_source") RETURNS "keys_~type._plots_04_count_of_plots_in_each_project_in_this_sou"
|
| 2049 |
2409 |
LANGUAGE sql IMMUTABLE
|
| 2050 |
2410 |
AS $_$
|
| 2051 |
|
SELECT ($1.project_name)
|
|
2411 |
SELECT ROW($1.project_name)::public_validations."keys_~type._plots_04_count_of_plots_in_each_project_in_this_source"
|
| 2052 |
2412 |
$_$;
|
| 2053 |
2413 |
|
| 2054 |
2414 |
|
| ... | ... | |
| 2066 |
2426 |
-- Name: keys("~type._plots_05_list_of_plot_codes_by_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2067 |
2427 |
--
|
| 2068 |
2428 |
|
| 2069 |
|
CREATE FUNCTION keys(value "~type._plots_05_list_of_plot_codes_by_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2429 |
CREATE FUNCTION keys(value "~type._plots_05_list_of_plot_codes_by_project") RETURNS "keys_~type._plots_05_list_of_plot_codes_by_project"
|
| 2070 |
2430 |
LANGUAGE sql IMMUTABLE
|
| 2071 |
2431 |
AS $_$
|
| 2072 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2432 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_05_list_of_plot_codes_by_project"
|
| 2073 |
2433 |
$_$;
|
| 2074 |
2434 |
|
| 2075 |
2435 |
|
| ... | ... | |
| 2087 |
2447 |
-- Name: keys("~type._plots_06_list_of_plots_with_stem_measurements"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2088 |
2448 |
--
|
| 2089 |
2449 |
|
| 2090 |
|
CREATE FUNCTION keys(value "~type._plots_06_list_of_plots_with_stem_measurements", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2450 |
CREATE FUNCTION keys(value "~type._plots_06_list_of_plots_with_stem_measurements") RETURNS "keys_~type._plots_06_list_of_plots_with_stem_measurements"
|
| 2091 |
2451 |
LANGUAGE sql IMMUTABLE
|
| 2092 |
2452 |
AS $_$
|
| 2093 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2453 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_06_list_of_plots_with_stem_measurements"
|
| 2094 |
2454 |
$_$;
|
| 2095 |
2455 |
|
| 2096 |
2456 |
|
| ... | ... | |
| 2109 |
2469 |
-- Name: keys("~type._plots_10_count_of_individuals_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2110 |
2470 |
--
|
| 2111 |
2471 |
|
| 2112 |
|
CREATE FUNCTION keys(value "~type._plots_10_count_of_individuals_per_plot_in_each_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2472 |
CREATE FUNCTION keys(value "~type._plots_10_count_of_individuals_per_plot_in_each_project") RETURNS "keys_~type._plots_10_count_of_individuals_per_plot_in_each_proj"
|
| 2113 |
2473 |
LANGUAGE sql IMMUTABLE
|
| 2114 |
2474 |
AS $_$
|
| 2115 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2475 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_10_count_of_individuals_per_plot_in_each_project"
|
| 2116 |
2476 |
$_$;
|
| 2117 |
2477 |
|
| 2118 |
2478 |
|
| ... | ... | |
| 2131 |
2491 |
-- Name: keys("~type._plots_11_count_of_stems_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2132 |
2492 |
--
|
| 2133 |
2493 |
|
| 2134 |
|
CREATE FUNCTION keys(value "~type._plots_11_count_of_stems_per_plot_in_each_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2494 |
CREATE FUNCTION keys(value "~type._plots_11_count_of_stems_per_plot_in_each_project") RETURNS "keys_~type._plots_11_count_of_stems_per_plot_in_each_project"
|
| 2135 |
2495 |
LANGUAGE sql IMMUTABLE
|
| 2136 |
2496 |
AS $_$
|
| 2137 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2497 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_11_count_of_stems_per_plot_in_each_project"
|
| 2138 |
2498 |
$_$;
|
| 2139 |
2499 |
|
| 2140 |
2500 |
|
| ... | ... | |
| 2153 |
2513 |
-- Name: keys("~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2154 |
2514 |
--
|
| 2155 |
2515 |
|
| 2156 |
|
CREATE FUNCTION keys(value "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2516 |
CREATE FUNCTION keys(value "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project") RETURNS "keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_pr"
|
| 2157 |
2517 |
LANGUAGE sql IMMUTABLE
|
| 2158 |
2518 |
AS $_$
|
| 2159 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2519 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project"
|
| 2160 |
2520 |
$_$;
|
| 2161 |
2521 |
|
| 2162 |
2522 |
|
| ... | ... | |
| 2175 |
2535 |
-- Name: keys("~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2176 |
2536 |
--
|
| 2177 |
2537 |
|
| 2178 |
|
CREATE FUNCTION keys(value "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_", OUT project_name text, OUT plot_code text, OUT taxon text) RETURNS record
|
|
2538 |
CREATE FUNCTION keys(value "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_") RETURNS "keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plo"
|
| 2179 |
2539 |
LANGUAGE sql IMMUTABLE
|
| 2180 |
2540 |
AS $_$
|
| 2181 |
|
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)
|
|
2541 |
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)::public_validations."keys_~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_"
|
| 2182 |
2542 |
$_$;
|
| 2183 |
2543 |
|
| 2184 |
2544 |
|
| ... | ... | |
| 2198 |
2558 |
-- Name: keys("~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2199 |
2559 |
--
|
| 2200 |
2560 |
|
| 2201 |
|
CREATE FUNCTION keys(value "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e", OUT project_name text, OUT plot_code text, OUT taxon text) RETURNS record
|
|
2561 |
CREATE FUNCTION keys(value "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e") RETURNS "keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot"
|
| 2202 |
2562 |
LANGUAGE sql IMMUTABLE
|
| 2203 |
2563 |
AS $_$
|
| 2204 |
|
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)
|
|
2564 |
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)::public_validations."keys_~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e"
|
| 2205 |
2565 |
$_$;
|
| 2206 |
2566 |
|
| 2207 |
2567 |
|
| ... | ... | |
| 2220 |
2580 |
-- Name: keys("~type._plots_17_count_of_subplots_per_plot_for_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2221 |
2581 |
--
|
| 2222 |
2582 |
|
| 2223 |
|
CREATE FUNCTION keys(value "~type._plots_17_count_of_subplots_per_plot_for_each_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
2583 |
CREATE FUNCTION keys(value "~type._plots_17_count_of_subplots_per_plot_for_each_project") RETURNS "keys_~type._plots_17_count_of_subplots_per_plot_for_each_projec"
|
| 2224 |
2584 |
LANGUAGE sql IMMUTABLE
|
| 2225 |
2585 |
AS $_$
|
| 2226 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
2586 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."keys_~type._plots_17_count_of_subplots_per_plot_for_each_project"
|
| 2227 |
2587 |
$_$;
|
| 2228 |
2588 |
|
| 2229 |
2589 |
|
| 2230 |
2590 |
--
|
| 2231 |
|
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace:
|
| 2232 |
|
--
|
| 2233 |
|
|
| 2234 |
|
CREATE TABLE "~type._traits_01_count_records" (
|
| 2235 |
|
"totalRecords" bigint
|
| 2236 |
|
);
|
| 2237 |
|
|
| 2238 |
|
|
| 2239 |
|
--
|
| 2240 |
|
-- Name: keys("~type._traits_01_count_records"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2241 |
|
--
|
| 2242 |
|
|
| 2243 |
|
CREATE FUNCTION keys(value "~type._traits_01_count_records") RETURNS record
|
| 2244 |
|
LANGUAGE sql IMMUTABLE
|
| 2245 |
|
AS $$
|
| 2246 |
|
SELECT ROW()
|
| 2247 |
|
$$;
|
| 2248 |
|
|
| 2249 |
|
|
| 2250 |
|
--
|
| 2251 |
2591 |
-- Name: ~type._traits_02_count_trait_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace:
|
| 2252 |
2592 |
--
|
| 2253 |
2593 |
|
| ... | ... | |
| 2260 |
2600 |
-- Name: keys("~type._traits_02_count_trait_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2261 |
2601 |
--
|
| 2262 |
2602 |
|
| 2263 |
|
CREATE FUNCTION keys(value "~type._traits_02_count_trait_names") RETURNS record
|
|
2603 |
CREATE FUNCTION keys(value "~type._traits_02_count_trait_names") RETURNS "keys_~type._traits_02_count_trait_names"
|
| 2264 |
2604 |
LANGUAGE sql IMMUTABLE
|
| 2265 |
2605 |
AS $$
|
| 2266 |
|
SELECT ROW()
|
|
2606 |
SELECT ROW()::public_validations."keys_~type._traits_02_count_trait_names"
|
| 2267 |
2607 |
$$;
|
| 2268 |
2608 |
|
| 2269 |
2609 |
|
| ... | ... | |
| 2280 |
2620 |
-- Name: keys("~type._traits_03_list_trait_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2281 |
2621 |
--
|
| 2282 |
2622 |
|
| 2283 |
|
CREATE FUNCTION keys(value "~type._traits_03_list_trait_names", OUT trait text) RETURNS text
|
|
2623 |
CREATE FUNCTION keys(value "~type._traits_03_list_trait_names") RETURNS "keys_~type._traits_03_list_trait_names"
|
| 2284 |
2624 |
LANGUAGE sql IMMUTABLE
|
| 2285 |
2625 |
AS $_$
|
| 2286 |
|
SELECT ($1.trait)
|
|
2626 |
SELECT ROW($1.trait)::public_validations."keys_~type._traits_03_list_trait_names"
|
| 2287 |
2627 |
$_$;
|
| 2288 |
2628 |
|
| 2289 |
2629 |
|
| ... | ... | |
| 2301 |
2641 |
-- Name: keys("~type._traits_04_count_records_per_trait"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2302 |
2642 |
--
|
| 2303 |
2643 |
|
| 2304 |
|
CREATE FUNCTION keys(value "~type._traits_04_count_records_per_trait", OUT trait text) RETURNS text
|
|
2644 |
CREATE FUNCTION keys(value "~type._traits_04_count_records_per_trait") RETURNS "keys_~type._traits_04_count_records_per_trait"
|
| 2305 |
2645 |
LANGUAGE sql IMMUTABLE
|
| 2306 |
2646 |
AS $_$
|
| 2307 |
|
SELECT ($1.trait)
|
|
2647 |
SELECT ROW($1.trait)::public_validations."keys_~type._traits_04_count_records_per_trait"
|
| 2308 |
2648 |
$_$;
|
| 2309 |
2649 |
|
| 2310 |
2650 |
|
| ... | ... | |
| 2321 |
2661 |
-- Name: keys("~type._traits_05_count_taxa"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2322 |
2662 |
--
|
| 2323 |
2663 |
|
| 2324 |
|
CREATE FUNCTION keys(value "~type._traits_05_count_taxa") RETURNS record
|
|
2664 |
CREATE FUNCTION keys(value "~type._traits_05_count_taxa") RETURNS "keys_~type._traits_05_count_taxa"
|
| 2325 |
2665 |
LANGUAGE sql IMMUTABLE
|
| 2326 |
2666 |
AS $$
|
| 2327 |
|
SELECT ROW()
|
|
2667 |
SELECT ROW()::public_validations."keys_~type._traits_05_count_taxa"
|
| 2328 |
2668 |
$$;
|
| 2329 |
2669 |
|
| 2330 |
2670 |
|
| ... | ... | |
| 2341 |
2681 |
-- Name: keys("~type._traits_06_list_distinct_taxa"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2342 |
2682 |
--
|
| 2343 |
2683 |
|
| 2344 |
|
CREATE FUNCTION keys(value "~type._traits_06_list_distinct_taxa", OUT taxonwithauthor text) RETURNS text
|
|
2684 |
CREATE FUNCTION keys(value "~type._traits_06_list_distinct_taxa") RETURNS "keys_~type._traits_06_list_distinct_taxa"
|
| 2345 |
2685 |
LANGUAGE sql IMMUTABLE
|
| 2346 |
2686 |
AS $_$
|
| 2347 |
|
SELECT ($1.taxonwithauthor)
|
|
2687 |
SELECT ROW($1.taxonwithauthor)::public_validations."keys_~type._traits_06_list_distinct_taxa"
|
| 2348 |
2688 |
$_$;
|
| 2349 |
2689 |
|
| 2350 |
2690 |
|
| ... | ... | |
| 2363 |
2703 |
-- Name: keys("~type._traits_07_trait_value_and_units"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2364 |
2704 |
--
|
| 2365 |
2705 |
|
| 2366 |
|
CREATE FUNCTION keys(value "~type._traits_07_trait_value_and_units", OUT trait text, OUT value text, OUT units text) RETURNS record
|
|
2706 |
CREATE FUNCTION keys(value "~type._traits_07_trait_value_and_units") RETURNS "keys_~type._traits_07_trait_value_and_units"
|
| 2367 |
2707 |
LANGUAGE sql IMMUTABLE
|
| 2368 |
2708 |
AS $_$
|
| 2369 |
|
SELECT ROW($1.trait, $1.value, $1.units)
|
|
2709 |
SELECT ROW($1.trait, $1.value, $1.units)::public_validations."keys_~type._traits_07_trait_value_and_units"
|
| 2370 |
2710 |
$_$;
|
| 2371 |
2711 |
|
| 2372 |
2712 |
|
| ... | ... | |
| 2385 |
2725 |
-- Name: keys("~type._traits_08_taxonname_trait_and_value"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2386 |
2726 |
--
|
| 2387 |
2727 |
|
| 2388 |
|
CREATE FUNCTION keys(value "~type._traits_08_taxonname_trait_and_value", OUT taxonwithauthor text, OUT trait text, OUT value text) RETURNS record
|
|
2728 |
CREATE FUNCTION keys(value "~type._traits_08_taxonname_trait_and_value") RETURNS "keys_~type._traits_08_taxonname_trait_and_value"
|
| 2389 |
2729 |
LANGUAGE sql IMMUTABLE
|
| 2390 |
2730 |
AS $_$
|
| 2391 |
|
SELECT ROW($1.taxonwithauthor, $1.trait, $1.value)
|
|
2731 |
SELECT ROW($1.taxonwithauthor, $1.trait, $1.value)::public_validations."keys_~type._traits_08_taxonname_trait_and_value"
|
| 2392 |
2732 |
$_$;
|
| 2393 |
2733 |
|
| 2394 |
2734 |
|
| ... | ... | |
| 2881 |
3221 |
-- Name: values_("~type._plots_01_count_of_projects"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2882 |
3222 |
--
|
| 2883 |
3223 |
|
| 2884 |
|
CREATE FUNCTION values_(value "~type._plots_01_count_of_projects", OUT projects bigint) RETURNS bigint
|
|
3224 |
CREATE FUNCTION values_(value "~type._plots_01_count_of_projects") RETURNS "values__~type._plots_01_count_of_projects"
|
| 2885 |
3225 |
LANGUAGE sql IMMUTABLE
|
| 2886 |
3226 |
AS $_$
|
| 2887 |
|
SELECT ($1.projects)
|
|
3227 |
SELECT ROW($1.projects)::public_validations."values__~type._plots_01_count_of_projects"
|
| 2888 |
3228 |
$_$;
|
| 2889 |
3229 |
|
| 2890 |
3230 |
|
| ... | ... | |
| 2892 |
3232 |
-- Name: values_("~type._plots_02_list_of_project_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2893 |
3233 |
--
|
| 2894 |
3234 |
|
| 2895 |
|
CREATE FUNCTION values_(value "~type._plots_02_list_of_project_names", OUT project_name text) RETURNS text
|
|
3235 |
CREATE FUNCTION values_(value "~type._plots_02_list_of_project_names") RETURNS "values__~type._plots_02_list_of_project_names"
|
| 2896 |
3236 |
LANGUAGE sql IMMUTABLE
|
| 2897 |
3237 |
AS $_$
|
| 2898 |
|
SELECT ($1.project_name)
|
|
3238 |
SELECT ROW($1.project_name)::public_validations."values__~type._plots_02_list_of_project_names"
|
| 2899 |
3239 |
$_$;
|
| 2900 |
3240 |
|
| 2901 |
3241 |
|
| ... | ... | |
| 2903 |
3243 |
-- Name: values_("~type._plots_03_count_of_all_plots_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2904 |
3244 |
--
|
| 2905 |
3245 |
|
| 2906 |
|
CREATE FUNCTION values_(value "~type._plots_03_count_of_all_plots_in_this_source", OUT plots bigint) RETURNS bigint
|
|
3246 |
CREATE FUNCTION values_(value "~type._plots_03_count_of_all_plots_in_this_source") RETURNS "values__~type._plots_03_count_of_all_plots_in_this_source"
|
| 2907 |
3247 |
LANGUAGE sql IMMUTABLE
|
| 2908 |
3248 |
AS $_$
|
| 2909 |
|
SELECT ($1.plots)
|
|
3249 |
SELECT ROW($1.plots)::public_validations."values__~type._plots_03_count_of_all_plots_in_this_source"
|
| 2910 |
3250 |
$_$;
|
| 2911 |
3251 |
|
| 2912 |
3252 |
|
| ... | ... | |
| 2914 |
3254 |
-- Name: values_("~type._plots_04_count_of_plots_in_each_project_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2915 |
3255 |
--
|
| 2916 |
3256 |
|
| 2917 |
|
CREATE FUNCTION values_(value "~type._plots_04_count_of_plots_in_each_project_in_this_source", OUT plots bigint) RETURNS bigint
|
|
3257 |
CREATE FUNCTION values_(value "~type._plots_04_count_of_plots_in_each_project_in_this_source") RETURNS "values__~type._plots_04_count_of_plots_in_each_project_in_this_"
|
| 2918 |
3258 |
LANGUAGE sql IMMUTABLE
|
| 2919 |
3259 |
AS $_$
|
| 2920 |
|
SELECT ($1.plots)
|
|
3260 |
SELECT ROW($1.plots)::public_validations."values__~type._plots_04_count_of_plots_in_each_project_in_this_source"
|
| 2921 |
3261 |
$_$;
|
| 2922 |
3262 |
|
| 2923 |
3263 |
|
| ... | ... | |
| 2925 |
3265 |
-- Name: values_("~type._plots_05_list_of_plot_codes_by_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2926 |
3266 |
--
|
| 2927 |
3267 |
|
| 2928 |
|
CREATE FUNCTION values_(value "~type._plots_05_list_of_plot_codes_by_project", OUT project_name text, OUT plot_code text) RETURNS record
|
|
3268 |
CREATE FUNCTION values_(value "~type._plots_05_list_of_plot_codes_by_project") RETURNS "values__~type._plots_05_list_of_plot_codes_by_project"
|
| 2929 |
3269 |
LANGUAGE sql IMMUTABLE
|
| 2930 |
3270 |
AS $_$
|
| 2931 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
3271 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."values__~type._plots_05_list_of_plot_codes_by_project"
|
| 2932 |
3272 |
$_$;
|
| 2933 |
3273 |
|
| 2934 |
3274 |
|
| ... | ... | |
| 2936 |
3276 |
-- Name: values_("~type._plots_06_list_of_plots_with_stem_measurements"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2937 |
3277 |
--
|
| 2938 |
3278 |
|
| 2939 |
|
CREATE FUNCTION values_(value "~type._plots_06_list_of_plots_with_stem_measurements", OUT project_name text, OUT plot_code text) RETURNS record
|
|
3279 |
CREATE FUNCTION values_(value "~type._plots_06_list_of_plots_with_stem_measurements") RETURNS "values__~type._plots_06_list_of_plots_with_stem_measurements"
|
| 2940 |
3280 |
LANGUAGE sql IMMUTABLE
|
| 2941 |
3281 |
AS $_$
|
| 2942 |
|
SELECT ROW($1.project_name, $1.plot_code)
|
|
3282 |
SELECT ROW($1.project_name, $1.plot_code)::public_validations."values__~type._plots_06_list_of_plots_with_stem_measurements"
|
| 2943 |
3283 |
$_$;
|
| 2944 |
3284 |
|
| 2945 |
3285 |
|
| ... | ... | |
| 2947 |
3287 |
-- Name: values_("~type._plots_10_count_of_individuals_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2948 |
3288 |
--
|
| 2949 |
3289 |
|
| 2950 |
|
CREATE FUNCTION values_(value "~type._plots_10_count_of_individuals_per_plot_in_each_project", OUT individuals bigint) RETURNS bigint
|
|
3290 |
CREATE FUNCTION values_(value "~type._plots_10_count_of_individuals_per_plot_in_each_project") RETURNS "values__~type._plots_10_count_of_individuals_per_plot_in_each_p"
|
| 2951 |
3291 |
LANGUAGE sql IMMUTABLE
|
| 2952 |
3292 |
AS $_$
|
| 2953 |
|
SELECT ($1.individuals)
|
|
3293 |
SELECT ROW($1.individuals)::public_validations."values__~type._plots_10_count_of_individuals_per_plot_in_each_project"
|
| 2954 |
3294 |
$_$;
|
| 2955 |
3295 |
|
| 2956 |
3296 |
|
| ... | ... | |
| 2958 |
3298 |
-- Name: values_("~type._plots_11_count_of_stems_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2959 |
3299 |
--
|
| 2960 |
3300 |
|
| 2961 |
|
CREATE FUNCTION values_(value "~type._plots_11_count_of_stems_per_plot_in_each_project", OUT stems bigint) RETURNS bigint
|
|
3301 |
CREATE FUNCTION values_(value "~type._plots_11_count_of_stems_per_plot_in_each_project") RETURNS "values__~type._plots_11_count_of_stems_per_plot_in_each_project"
|
| 2962 |
3302 |
LANGUAGE sql IMMUTABLE
|
| 2963 |
3303 |
AS $_$
|
| 2964 |
|
SELECT ($1.stems)
|
|
3304 |
SELECT ROW($1.stems)::public_validations."values__~type._plots_11_count_of_stems_per_plot_in_each_project"
|
| 2965 |
3305 |
$_$;
|
| 2966 |
3306 |
|
| 2967 |
3307 |
|
| ... | ... | |
| 2969 |
3309 |
-- Name: values_("~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2970 |
3310 |
--
|
| 2971 |
3311 |
|
| 2972 |
|
CREATE FUNCTION values_(value "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project", OUT taxa bigint) RETURNS bigint
|
|
3312 |
CREATE FUNCTION values_(value "~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project") RETURNS "values__~type._plots_12_count_of_verbatim_taxa_per_plot_in_each"
|
| 2973 |
3313 |
LANGUAGE sql IMMUTABLE
|
| 2974 |
3314 |
AS $_$
|
| 2975 |
|
SELECT ($1.taxa)
|
|
3315 |
SELECT ROW($1.taxa)::public_validations."values__~type._plots_12_count_of_verbatim_taxa_per_plot_in_each_project"
|
| 2976 |
3316 |
$_$;
|
| 2977 |
3317 |
|
| 2978 |
3318 |
|
| ... | ... | |
| 2980 |
3320 |
-- Name: values_("~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2981 |
3321 |
--
|
| 2982 |
3322 |
|
| 2983 |
|
CREATE FUNCTION values_(value "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_", OUT project_name text, OUT plot_code text, OUT taxon text) RETURNS record
|
|
3323 |
CREATE FUNCTION values_(value "~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_") RETURNS "values__~type._plots_13_list_of_distinct_verbatim_taxa_in_each_"
|
| 2984 |
3324 |
LANGUAGE sql IMMUTABLE
|
| 2985 |
3325 |
AS $_$
|
| 2986 |
|
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)
|
|
3326 |
SELECT ROW($1.project_name, $1.plot_code, $1.taxon)::public_validations."values__~type._plots_13_list_of_distinct_verbatim_taxa_in_each_plot_in_"
|
| 2987 |
3327 |
$_$;
|
| 2988 |
3328 |
|
| 2989 |
3329 |
|
| ... | ... | |
| 2991 |
3331 |
-- Name: values_("~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 2992 |
3332 |
--
|
| 2993 |
3333 |
|
| 2994 |
|
CREATE FUNCTION values_(value "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e", OUT individuals bigint) RETURNS bigint
|
|
3334 |
CREATE FUNCTION values_(value "~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e") RETURNS "values__~type._plots_14_count_of_indiv_per_verbatim_taxon_per_p"
|
| 2995 |
3335 |
LANGUAGE sql IMMUTABLE
|
| 2996 |
3336 |
AS $_$
|
| 2997 |
|
SELECT ($1.individuals)
|
|
3337 |
SELECT ROW($1.individuals)::public_validations."values__~type._plots_14_count_of_indiv_per_verbatim_taxon_per_plot_in_e"
|
| 2998 |
3338 |
$_$;
|
| 2999 |
3339 |
|
| 3000 |
3340 |
|
| ... | ... | |
| 3002 |
3342 |
-- Name: values_("~type._plots_17_count_of_subplots_per_plot_for_each_project"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3003 |
3343 |
--
|
| 3004 |
3344 |
|
| 3005 |
|
CREATE FUNCTION values_(value "~type._plots_17_count_of_subplots_per_plot_for_each_project", OUT subplots bigint) RETURNS bigint
|
|
3345 |
CREATE FUNCTION values_(value "~type._plots_17_count_of_subplots_per_plot_for_each_project") RETURNS "values__~type._plots_17_count_of_subplots_per_plot_for_each_pro"
|
| 3006 |
3346 |
LANGUAGE sql IMMUTABLE
|
| 3007 |
3347 |
AS $_$
|
| 3008 |
|
SELECT ($1.subplots)
|
|
3348 |
SELECT ROW($1.subplots)::public_validations."values__~type._plots_17_count_of_subplots_per_plot_for_each_project"
|
| 3009 |
3349 |
$_$;
|
| 3010 |
3350 |
|
| 3011 |
3351 |
|
| ... | ... | |
| 3013 |
3353 |
-- Name: values_("~type._traits_02_count_trait_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3014 |
3354 |
--
|
| 3015 |
3355 |
|
| 3016 |
|
CREATE FUNCTION values_(value "~type._traits_02_count_trait_names", OUT traits bigint) RETURNS bigint
|
|
3356 |
CREATE FUNCTION values_(value "~type._traits_02_count_trait_names") RETURNS "values__~type._traits_02_count_trait_names"
|
| 3017 |
3357 |
LANGUAGE sql IMMUTABLE
|
| 3018 |
3358 |
AS $_$
|
| 3019 |
|
SELECT ($1.traits)
|
|
3359 |
SELECT ROW($1.traits)::public_validations."values__~type._traits_02_count_trait_names"
|
| 3020 |
3360 |
$_$;
|
| 3021 |
3361 |
|
| 3022 |
3362 |
|
| ... | ... | |
| 3024 |
3364 |
-- Name: values_("~type._traits_03_list_trait_names"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3025 |
3365 |
--
|
| 3026 |
3366 |
|
| 3027 |
|
CREATE FUNCTION values_(value "~type._traits_03_list_trait_names", OUT trait text) RETURNS text
|
|
3367 |
CREATE FUNCTION values_(value "~type._traits_03_list_trait_names") RETURNS "values__~type._traits_03_list_trait_names"
|
| 3028 |
3368 |
LANGUAGE sql IMMUTABLE
|
| 3029 |
3369 |
AS $_$
|
| 3030 |
|
SELECT ($1.trait)
|
|
3370 |
SELECT ROW($1.trait)::public_validations."values__~type._traits_03_list_trait_names"
|
| 3031 |
3371 |
$_$;
|
| 3032 |
3372 |
|
| 3033 |
3373 |
|
| ... | ... | |
| 3035 |
3375 |
-- Name: values_("~type._traits_04_count_records_per_trait"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3036 |
3376 |
--
|
| 3037 |
3377 |
|
| 3038 |
|
CREATE FUNCTION values_(value "~type._traits_04_count_records_per_trait", OUT measurements bigint) RETURNS bigint
|
|
3378 |
CREATE FUNCTION values_(value "~type._traits_04_count_records_per_trait") RETURNS "values__~type._traits_04_count_records_per_trait"
|
| 3039 |
3379 |
LANGUAGE sql IMMUTABLE
|
| 3040 |
3380 |
AS $_$
|
| 3041 |
|
SELECT ($1.measurements)
|
|
3381 |
SELECT ROW($1.measurements)::public_validations."values__~type._traits_04_count_records_per_trait"
|
| 3042 |
3382 |
$_$;
|
| 3043 |
3383 |
|
| 3044 |
3384 |
|
| ... | ... | |
| 3046 |
3386 |
-- Name: values_("~type._traits_05_count_taxa"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3047 |
3387 |
--
|
| 3048 |
3388 |
|
| 3049 |
|
CREATE FUNCTION values_(value "~type._traits_05_count_taxa", OUT taxa bigint) RETURNS bigint
|
|
3389 |
CREATE FUNCTION values_(value "~type._traits_05_count_taxa") RETURNS "values__~type._traits_05_count_taxa"
|
| 3050 |
3390 |
LANGUAGE sql IMMUTABLE
|
| 3051 |
3391 |
AS $_$
|
| 3052 |
|
SELECT ($1.taxa)
|
|
3392 |
SELECT ROW($1.taxa)::public_validations."values__~type._traits_05_count_taxa"
|
| 3053 |
3393 |
$_$;
|
| 3054 |
3394 |
|
| 3055 |
3395 |
|
| ... | ... | |
| 3057 |
3397 |
-- Name: values_("~type._traits_06_list_distinct_taxa"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3058 |
3398 |
--
|
| 3059 |
3399 |
|
| 3060 |
|
CREATE FUNCTION values_(value "~type._traits_06_list_distinct_taxa", OUT taxonwithauthor text) RETURNS text
|
|
3400 |
CREATE FUNCTION values_(value "~type._traits_06_list_distinct_taxa") RETURNS "values__~type._traits_06_list_distinct_taxa"
|
| 3061 |
3401 |
LANGUAGE sql IMMUTABLE
|
| 3062 |
3402 |
AS $_$
|
| 3063 |
|
SELECT ($1.taxonwithauthor)
|
|
3403 |
SELECT ROW($1.taxonwithauthor)::public_validations."values__~type._traits_06_list_distinct_taxa"
|
| 3064 |
3404 |
$_$;
|
| 3065 |
3405 |
|
| 3066 |
3406 |
|
| ... | ... | |
| 3068 |
3408 |
-- Name: values_("~type._traits_07_trait_value_and_units"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3069 |
3409 |
--
|
| 3070 |
3410 |
|
| 3071 |
|
CREATE FUNCTION values_(value "~type._traits_07_trait_value_and_units", OUT trait text, OUT value text, OUT units text) RETURNS record
|
|
3411 |
CREATE FUNCTION values_(value "~type._traits_07_trait_value_and_units") RETURNS "values__~type._traits_07_trait_value_and_units"
|
| 3072 |
3412 |
LANGUAGE sql IMMUTABLE
|
| 3073 |
3413 |
AS $_$
|
| 3074 |
|
SELECT ROW($1.trait, $1.value, $1.units)
|
|
3414 |
SELECT ROW($1.trait, $1.value, $1.units)::public_validations."values__~type._traits_07_trait_value_and_units"
|
| 3075 |
3415 |
$_$;
|
| 3076 |
3416 |
|
| 3077 |
3417 |
|
| ... | ... | |
| 3079 |
3419 |
-- Name: values_("~type._traits_08_taxonname_trait_and_value"); Type: FUNCTION; Schema: public_validations; Owner: -
|
| 3080 |
3420 |
--
|
| 3081 |
3421 |
|
| 3082 |
|
CREATE FUNCTION values_(value "~type._traits_08_taxonname_trait_and_value", OUT taxonwithauthor text, OUT trait text, OUT value text) RETURNS record
|
|
3422 |
CREATE FUNCTION values_(value "~type._traits_08_taxonname_trait_and_value") RETURNS "values__~type._traits_08_taxonname_trait_and_value"
|
| 3083 |
3423 |
LANGUAGE sql IMMUTABLE
|
| 3084 |
3424 |
AS $_$
|
| 3085 |
|
SELECT ROW($1.taxonwithauthor, $1.trait, $1.value)
|
|
3425 |
SELECT ROW($1.taxonwithauthor, $1.trait, $1.value)::public_validations."values__~type._traits_08_taxonname_trait_and_value"
|
| 3086 |
3426 |
$_$;
|
| 3087 |
3427 |
|
| 3088 |
3428 |
|
| ... | ... | |
| 7003 |
7343 |
ORDER BY taxonverbatim.taxonname;
|
| 7004 |
7344 |
|
| 7005 |
7345 |
|
|
7346 |
--
|
|
7347 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace:
|
|
7348 |
--
|
|
7349 |
|
|
7350 |
CREATE TABLE "~type._traits_01_count_records" (
|
|
7351 |
"totalRecords" bigint
|
|
7352 |
);
|
|
7353 |
|
|
7354 |
|
| 7006 |
7355 |
SET search_path = public, pg_catalog;
|
| 7007 |
7356 |
|
| 7008 |
7357 |
--
|
schemas/vegbien.sql: public_validations: re-auto-added keys(), values_() functions for all queries