Revision 13910
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 1681 | 1681 |
|
| 1682 | 1682 |
|
| 1683 | 1683 |
-- |
| 1684 |
-- Name: subspecies(varchar(255)); Type: FUNCTION; Schema: public; Owner: - |
|
| 1685 |
-- |
|
| 1686 |
|
|
| 1687 |
|
|
| 1688 |
|
|
| 1689 |
|
|
| 1690 |
-- |
|
| 1691 |
-- Name: FUNCTION subspecies(taxon_name varchar(255)); Type: COMMENT; Schema: public; Owner: - |
|
| 1692 |
-- |
|
| 1693 |
|
|
| 1694 |
|
|
| 1695 |
|
|
| 1696 |
|
|
| 1697 |
-- |
|
| 1684 | 1698 |
-- Name: taxon_trait_view_modify(); Type: FUNCTION; Schema: public; Owner: - |
| 1685 | 1699 |
-- |
| 1686 | 1700 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 2946 | 2946 |
|
| 2947 | 2947 |
|
| 2948 | 2948 |
-- |
| 2949 |
-- Name: subspecies(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 2950 |
-- |
|
| 2951 |
|
|
| 2952 |
CREATE FUNCTION subspecies(taxon_name text) RETURNS text |
|
| 2953 |
LANGUAGE sql IMMUTABLE |
|
| 2954 |
AS $_$ |
|
| 2955 |
SELECT util.subspecies($1) |
|
| 2956 |
$_$; |
|
| 2957 |
|
|
| 2958 |
|
|
| 2959 |
-- |
|
| 2960 |
-- Name: FUNCTION subspecies(taxon_name text); Type: COMMENT; Schema: public; Owner: - |
|
| 2961 |
-- |
|
| 2962 |
|
|
| 2963 |
COMMENT ON FUNCTION subspecies(taxon_name text) IS ' |
|
| 2964 |
wrapper that prevents views from getting dropped when the util schema is reinstalled |
|
| 2965 |
'; |
|
| 2966 |
|
|
| 2967 |
|
|
| 2968 |
-- |
|
| 2949 | 2969 |
-- Name: taxon_trait_view_modify(); Type: FUNCTION; Schema: public; Owner: - |
| 2950 | 2970 |
-- |
| 2951 | 2971 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 2946 | 2946 |
|
| 2947 | 2947 |
|
| 2948 | 2948 |
-- |
| 2949 |
-- Name: subspecies(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 2950 |
-- |
|
| 2951 |
|
|
| 2952 |
CREATE FUNCTION subspecies(taxon_name text) RETURNS text |
|
| 2953 |
LANGUAGE sql IMMUTABLE |
|
| 2954 |
AS $_$ |
|
| 2955 |
SELECT util.subspecies($1) |
|
| 2956 |
$_$; |
|
| 2957 |
|
|
| 2958 |
|
|
| 2959 |
-- |
|
| 2960 |
-- Name: FUNCTION subspecies(taxon_name text); Type: COMMENT; Schema: public; Owner: - |
|
| 2961 |
-- |
|
| 2962 |
|
|
| 2963 |
COMMENT ON FUNCTION subspecies(taxon_name text) IS ' |
|
| 2964 |
wrapper that prevents views from getting dropped when the util schema is reinstalled |
|
| 2965 |
'; |
|
| 2966 |
|
|
| 2967 |
|
|
| 2968 |
-- |
|
| 2949 | 2969 |
-- Name: taxon_trait_view_modify(); Type: FUNCTION; Schema: public; Owner: - |
| 2950 | 2970 |
-- |
| 2951 | 2971 |
|
Also available in: Unified diff
schemas/public_.sql: added subspecies() wrapper