Revision 12229
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1004 | 1004 |
|
| 1005 | 1005 |
|
| 1006 | 1006 |
-- |
| 1007 |
-- Name: drop_view(text); Type: FUNCTION; Schema: util; Owner: - |
|
| 1008 |
-- |
|
| 1009 |
|
|
| 1010 |
CREATE FUNCTION drop_view(view_ text) RETURNS void |
|
| 1011 |
LANGUAGE sql STRICT |
|
| 1012 |
AS $_$ |
|
| 1013 |
SELECT util.eval($$DROP VIEW IF EXISTS $$||$1) |
|
| 1014 |
$_$; |
|
| 1015 |
|
|
| 1016 |
|
|
| 1017 |
-- |
|
| 1018 |
-- Name: FUNCTION drop_view(view_ text); Type: COMMENT; Schema: util; Owner: - |
|
| 1019 |
-- |
|
| 1020 |
|
|
| 1021 |
COMMENT ON FUNCTION drop_view(view_ text) IS 'idempotent'; |
|
| 1022 |
|
|
| 1023 |
|
|
| 1024 |
-- |
|
| 1007 | 1025 |
-- Name: empty_array(anyelement); Type: FUNCTION; Schema: util; Owner: - |
| 1008 | 1026 |
-- |
| 1009 | 1027 |
|
Also available in: Unified diff
schemas/util.sql: added drop_view()