/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 12579

bugfix: schemas/util.sql: uses of util.col_cast.col_name: need to wrap in quote_ident()

       RETURNS $$||util.prefixed_name($3||'_', $1)||$$ AS
     $BODY1$
     SELECT ROW($$||
     (SELECT COALESCE(string_agg($$$1.$$||(unnest).col_name, ', '), '')
     (SELECT COALESCE(string_agg($$$1.$$||quote_ident((unnest).col_name), ', '), '')
     FROM unnest($2)) ||$$)::$$||util.prefixed_name($3||'_', $1)||$$
     $BODY1$
       LANGUAGE sql IMMUTABLE
-...
     CREATE FUNCTION mk_typed_cols_list(cols col_cast[]) RETURNS text
         LANGUAGE sql IMMUTABLE
         AS $_$
     SELECT COALESCE(string_agg((unnest).col_name||$$ $$||
     SELECT COALESCE(string_agg(quote_ident((unnest).col_name)||$$ $$||
     util.qual_name((unnest).type), ', '), '')
     FROM unnest($1)
     $_$;

Also available in: Unified diff