Project

General

Profile

« Previous | Next » 

Revision 2527

schemas/vegbien.sql: Changed cast functions' input types to text because type must match exactly, not just be implicitly castable

View differences:

schemas/vegbien.my.sql
110 110

  
111 111

  
112 112
--
113
-- Name: growthform(unknown); Type: FUNCTION; Schema: public; Owner: -
113
-- Name: growthform(text); Type: FUNCTION; Schema: public; Owner: -
114 114
--
115 115

  
116 116

  
......
124 124

  
125 125

  
126 126
--
127
-- Name: placerank(unknown); Type: FUNCTION; Schema: public; Owner: -
127
-- Name: placerank(text); Type: FUNCTION; Schema: public; Owner: -
128 128
--
129 129

  
130 130

  
......
138 138

  
139 139

  
140 140
--
141
-- Name: taxonrank(unknown); Type: FUNCTION; Schema: public; Owner: -
141
-- Name: taxonrank(text); Type: FUNCTION; Schema: public; Owner: -
142 142
--
143 143

  
144 144

  
schemas/vegbien.sql
254 254

  
255 255

  
256 256
--
257
-- Name: growthform(unknown); Type: FUNCTION; Schema: public; Owner: -
257
-- Name: growthform(text); Type: FUNCTION; Schema: public; Owner: -
258 258
--
259 259

  
260
CREATE FUNCTION growthform(value unknown) RETURNS growthform
260
CREATE FUNCTION growthform(value text) RETURNS growthform
261 261
    LANGUAGE plpgsql IMMUTABLE
262 262
    AS $$
263 263
BEGIN
......
324 324

  
325 325

  
326 326
--
327
-- Name: placerank(unknown); Type: FUNCTION; Schema: public; Owner: -
327
-- Name: placerank(text); Type: FUNCTION; Schema: public; Owner: -
328 328
--
329 329

  
330
CREATE FUNCTION placerank(value unknown) RETURNS placerank
330
CREATE FUNCTION placerank(value text) RETURNS placerank
331 331
    LANGUAGE plpgsql IMMUTABLE
332 332
    AS $$
333 333
BEGIN
......
394 394

  
395 395

  
396 396
--
397
-- Name: taxonrank(unknown); Type: FUNCTION; Schema: public; Owner: -
397
-- Name: taxonrank(text); Type: FUNCTION; Schema: public; Owner: -
398 398
--
399 399

  
400
CREATE FUNCTION taxonrank(value unknown) RETURNS taxonrank
400
CREATE FUNCTION taxonrank(value text) RETURNS taxonrank
401 401
    LANGUAGE plpgsql IMMUTABLE
402 402
    AS $$
403 403
BEGIN

Also available in: Unified diff