/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 13100

schemas/vegbien.sql: _specimens_16_list_distinct_specimen_descriptions: re-ran through pipeline after removing duplicated rows

     --
     CREATE TABLE `~type._specimens_16_list_distinct_specimen_descriptions` (
         `specimenDescription` varchar(255),
         copies varchar(255) NOT NULL
         `specimenDescription` varchar(255)
     );

     --
     CREATE TYPE "values__~type._specimens_16_list_distinct_specimen_descriptions" AS (
     	copies bigint
     	"specimenDescription" text
     );
-...
     --
     CREATE TABLE "~type._specimens_16_list_distinct_specimen_descriptions" (
         "specimenDescription" text,
         copies bigint NOT NULL
         "specimenDescription" text
     );
-...
     CREATE FUNCTION values_(value "~type._specimens_16_list_distinct_specimen_descriptions") RETURNS "values__~type._specimens_16_list_distinct_specimen_descriptions"
         LANGUAGE sql IMMUTABLE
         AS $_$
     SELECT ROW($1.copies)::public_validations."values__~type._specimens_16_list_distinct_specimen_descriptions"
     SELECT ROW($1."specimenDescription")::public_validations."values__~type._specimens_16_list_distinct_specimen_descriptions"
     $_$;

Also available in: Unified diff