Project

General

Profile

« Previous | Next » 

Revision 2554

schemas/vegbien.sql, functions.sql: Made cast functions STRICT to enable the RETURNS NULL ON NULL INPUT optimization

View differences:

schemas/functions.sql
23 23
--
24 24

  
25 25
CREATE FUNCTION "boolean"(value text) RETURNS boolean
26
    LANGUAGE plpgsql IMMUTABLE
26
    LANGUAGE plpgsql IMMUTABLE STRICT
27 27
    AS $$
28 28
BEGIN
29 29
    BEGIN
......
43 43
--
44 44

  
45 45
CREATE FUNCTION "double precision"(value text) RETURNS double precision
46
    LANGUAGE plpgsql IMMUTABLE
46
    LANGUAGE plpgsql IMMUTABLE STRICT
47 47
    AS $$
48 48
BEGIN
49 49
    BEGIN
......
63 63
--
64 64

  
65 65
CREATE FUNCTION "timestamp with time zone"(value text) RETURNS timestamp with time zone
66
    LANGUAGE plpgsql IMMUTABLE
66
    LANGUAGE plpgsql IMMUTABLE STRICT
67 67
    AS $$
68 68
BEGIN
69 69
    BEGIN
schemas/vegbien.sql
198 198
--
199 199

  
200 200
CREATE FUNCTION growthform(value text) RETURNS growthform
201
    LANGUAGE plpgsql IMMUTABLE
201
    LANGUAGE plpgsql IMMUTABLE STRICT
202 202
    AS $$
203 203
BEGIN
204 204
    BEGIN
......
268 268
--
269 269

  
270 270
CREATE FUNCTION placerank(value text) RETURNS placerank
271
    LANGUAGE plpgsql IMMUTABLE
271
    LANGUAGE plpgsql IMMUTABLE STRICT
272 272
    AS $$
273 273
BEGIN
274 274
    BEGIN
......
338 338
--
339 339

  
340 340
CREATE FUNCTION taxonrank(value text) RETURNS taxonrank
341
    LANGUAGE plpgsql IMMUTABLE
341
    LANGUAGE plpgsql IMMUTABLE STRICT
342 342
    AS $$
343 343
BEGIN
344 344
    BEGIN

Also available in: Unified diff