Project

General

Profile

« Previous | Next » 

Revision 13631

inputs/.TNRS/schema.sql: added unsafe_taxon_names()

View differences:

trunk/inputs/.TNRS/schema.sql
280 280
';
281 281

  
282 282

  
283
--
284
-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: -
285
--
286

  
287
CREATE FUNCTION unsafe_taxon_names() RETURNS text[]
288
    LANGUAGE sql IMMUTABLE
289
    AS $$
290
SELECT ARRAY[
291
'Lamiaceae Agastache pallidiflora (Heller) Rydb. spp. pallidiflora var. gilensis R.W. Sanders'
292
]
293
$$;
294

  
295

  
283 296
SET default_tablespace = '';
284 297

  
285 298
SET default_with_oids = false;
trunk/schemas/vegbien.my.sql
13261 13261

  
13262 13262

  
13263 13263

  
13264
--
13265
-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: -
13266
--
13267

  
13268

  
13269

  
13270

  
13264 13271
USE geoscrub;
13265 13272

  
13266 13273
--
trunk/schemas/vegbien.sql
17070 17070
';
17071 17071

  
17072 17072

  
17073
--
17074
-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: -
17075
--
17076

  
17077
CREATE FUNCTION unsafe_taxon_names() RETURNS text[]
17078
    LANGUAGE sql IMMUTABLE
17079
    AS $$
17080
SELECT ARRAY[
17081
'Lamiaceae Agastache pallidiflora (Heller) Rydb. spp. pallidiflora var. gilensis R.W. Sanders'
17082
]
17083
$$;
17084

  
17085

  
17073 17086
SET search_path = geoscrub, pg_catalog;
17074 17087

  
17075 17088
--

Also available in: Unified diff