Revision 13648
Added by Aaron Marcuse-Kubitza over 10 years ago
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
schemas/public_.sql: added plot.**.modify()