Revision 12425
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 868 | 868 |
|
| 869 | 869 |
|
| 870 | 870 |
-- |
| 871 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 872 |
-- |
|
| 873 |
|
|
| 874 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 875 |
project_name varchar(255), |
|
| 876 |
plots varchar(255) |
|
| 877 |
); |
|
| 878 |
|
|
| 879 |
|
|
| 880 |
-- |
|
| 881 |
-- Name: %==(`~type._plots_04_count_of_plots_in_each_project_in_this_source`, `~type._plots_04_count_of_plots_in_each_project_in_this_source`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 882 |
-- |
|
| 883 |
|
|
| 884 |
|
|
| 885 |
|
|
| 886 |
|
|
| 887 |
-- |
|
| 871 | 888 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 872 | 889 |
-- |
| 873 | 890 |
|
| ... | ... | |
| 1063 | 1080 |
); |
| 1064 | 1081 |
|
| 1065 | 1082 |
|
| 1083 |
-- |
|
| 1084 |
-- Name: %==; Type: OPERATOR; Schema: public_validations; Owner: - |
|
| 1085 |
-- |
|
| 1066 | 1086 |
|
| 1087 |
CREATE OPERATOR %== ( |
|
| 1088 |
PROCEDURE = `%==`, |
|
| 1089 |
LEFTARG = `~type._plots_04_count_of_plots_in_each_project_in_this_source`, |
|
| 1090 |
RIGHTARG = `~type._plots_04_count_of_plots_in_each_project_in_this_source` |
|
| 1091 |
); |
|
| 1067 | 1092 |
|
| 1093 |
|
|
| 1094 |
|
|
| 1095 |
|
|
| 1068 | 1096 |
-- |
| 1069 | 1097 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1070 | 1098 |
-- |
| ... | ... | |
| 3904 | 3932 |
|
| 3905 | 3933 |
|
| 3906 | 3934 |
-- |
| 3907 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3908 |
-- |
|
| 3909 |
|
|
| 3910 |
CREATE TABLE `~type._plots_04_count_of_plots_in_each_project_in_this_source` ( |
|
| 3911 |
project_name varchar(255), |
|
| 3912 |
plots varchar(255) |
|
| 3913 |
); |
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 | 3935 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3918 | 3936 |
-- |
| 3919 | 3937 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1951 | 1951 |
SET search_path = public_validations, pg_catalog; |
| 1952 | 1952 |
|
| 1953 | 1953 |
-- |
| 1954 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1955 |
-- |
|
| 1956 |
|
|
| 1957 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 1958 |
project_name text, |
|
| 1959 |
plots bigint |
|
| 1960 |
); |
|
| 1961 |
|
|
| 1962 |
|
|
| 1963 |
-- |
|
| 1964 |
-- Name: %==("~type._plots_04_count_of_plots_in_each_project_in_this_source", "~type._plots_04_count_of_plots_in_each_project_in_this_source"); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 1965 |
-- |
|
| 1966 |
|
|
| 1967 |
CREATE FUNCTION "%=="(left_ "~type._plots_04_count_of_plots_in_each_project_in_this_source", right_ "~type._plots_04_count_of_plots_in_each_project_in_this_source") RETURNS boolean |
|
| 1968 |
LANGUAGE sql IMMUTABLE |
|
| 1969 |
AS $_$ |
|
| 1970 |
SELECT $1.project_name = $2.project_name |
|
| 1971 |
$_$; |
|
| 1972 |
|
|
| 1973 |
|
|
| 1974 |
-- |
|
| 1954 | 1975 |
-- Name: ~type._traits_04_count_records_per_trait; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1955 | 1976 |
-- |
| 1956 | 1977 |
|
| ... | ... | |
| 2411 | 2432 |
); |
| 2412 | 2433 |
|
| 2413 | 2434 |
|
| 2435 |
-- |
|
| 2436 |
-- Name: %==; Type: OPERATOR; Schema: public_validations; Owner: - |
|
| 2437 |
-- |
|
| 2438 |
|
|
| 2439 |
CREATE OPERATOR %== ( |
|
| 2440 |
PROCEDURE = "%==", |
|
| 2441 |
LEFTARG = "~type._plots_04_count_of_plots_in_each_project_in_this_source", |
|
| 2442 |
RIGHTARG = "~type._plots_04_count_of_plots_in_each_project_in_this_source" |
|
| 2443 |
); |
|
| 2444 |
|
|
| 2445 |
|
|
| 2414 | 2446 |
SET search_path = public, pg_catalog; |
| 2415 | 2447 |
|
| 2416 | 2448 |
-- |
| ... | ... | |
| 6353 | 6385 |
|
| 6354 | 6386 |
|
| 6355 | 6387 |
-- |
| 6356 |
-- Name: ~type._plots_04_count_of_plots_in_each_project_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 6357 |
-- |
|
| 6358 |
|
|
| 6359 |
CREATE TABLE "~type._plots_04_count_of_plots_in_each_project_in_this_source" ( |
|
| 6360 |
project_name text, |
|
| 6361 |
plots bigint |
|
| 6362 |
); |
|
| 6363 |
|
|
| 6364 |
|
|
| 6365 |
-- |
|
| 6366 | 6388 |
-- Name: ~type._traits_01_count_records; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 6367 | 6389 |
-- |
| 6368 | 6390 |
|
Also available in: Unified diff
schemas/vegbien.sql: _plots_04_count_of_plots_in_each_project_in_this_source: added operator %== to match the rows by project_name