Revision 5667
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2649 | 2649 |
|
| 2650 | 2650 |
|
| 2651 | 2651 |
-- |
| 2652 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
|
| 2653 |
-- |
|
| 2654 |
|
|
| 2655 |
CREATE VIEW tnrs_input_name AS |
|
| 2656 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN `TNRS`.tnrs ON ((tnrs.`Name_submitted` = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs.`Name_submitted` IS NULL)) ORDER BY taxonlabel.taxonomicname; |
|
| 2657 |
|
|
| 2658 |
|
|
| 2659 |
-- |
|
| 2652 | 2660 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 2653 | 2661 |
-- |
| 2654 | 2662 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3400 | 3400 |
|
| 3401 | 3401 |
|
| 3402 | 3402 |
-- |
| 3403 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
|
| 3404 |
-- |
|
| 3405 |
|
|
| 3406 |
CREATE VIEW tnrs_input_name AS |
|
| 3407 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs."Name_submitted" IS NULL)) ORDER BY taxonlabel.taxonomicname; |
|
| 3408 |
|
|
| 3409 |
|
|
| 3410 |
-- |
|
| 3403 | 3411 |
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3404 | 3412 |
-- |
| 3405 | 3413 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added tnrs_input_name view for use by tnrs_db