Project

General

Profile

« Previous | Next » 

Revision 13648

schemas/public_.sql: added plot.**.modify()

View differences:

vegbien.sql
2667 2667

  
2668 2668

  
2669 2669
--
2670
-- Name: plot.**.modify(text, anyelement); Type: FUNCTION; Schema: public; Owner: -
2671
--
2672

  
2673
CREATE FUNCTION "plot.**.modify"(view_query text DEFAULT NULL::text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void
2674
    LANGUAGE plpgsql
2675
    AS $_$
2676
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime
2677
changes of search_path (schema elements are bound at inline time rather than
2678
runtime) */
2679
/* function option search_path is needed to limit the effects of
2680
`SET LOCAL search_path` to the current function */
2681
BEGIN
2682
	PERFORM util.use_schema(schema_anchor);
2683
	
2684
	PERFORM util.recreate_view('"plot.**"', $1);
2685
END;
2686
$_$;
2687

  
2688

  
2689
--
2690
-- Name: FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement); Type: COMMENT; Schema: public; Owner: -
2691
--
2692

  
2693
COMMENT ON FUNCTION "plot.**.modify"(view_query text, schema_anchor anyelement) IS '
2694
usage:
2695
SELECT "plot.**.modify"($$
2696
SELECT __
2697
$$);
2698

  
2699
idempotent
2700
';
2701

  
2702

  
2703
--
2670 2704
-- Name: project_contributors(integer); Type: FUNCTION; Schema: public; Owner: -
2671 2705
--
2672 2706

  

Also available in: Unified diff