/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 2554

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

     --
     CREATE FUNCTION "boolean"(value text) RETURNS boolean
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN
-...
     --
     CREATE FUNCTION "double precision"(value text) RETURNS double precision
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN
-...
     --
     CREATE FUNCTION "timestamp with time zone"(value text) RETURNS timestamp with time zone
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN

     --
     CREATE FUNCTION growthform(value text) RETURNS growthform
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN
-...
     --
     CREATE FUNCTION placerank(value text) RETURNS placerank
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN
-...
     --
     CREATE FUNCTION taxonrank(value text) RETURNS taxonrank
         LANGUAGE plpgsql IMMUTABLE
         LANGUAGE plpgsql IMMUTABLE STRICT
         AS $$
     BEGIN
         BEGIN

Also available in: Unified diff