Revision 12230
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1549 | 1549 |
-- Name: materialize_query(text, text); Type: FUNCTION; Schema: util; Owner: - |
| 1550 | 1550 |
-- |
| 1551 | 1551 |
|
| 1552 |
CREATE FUNCTION materialize_query(view_ text, sql text) RETURNS void
|
|
| 1552 |
CREATE FUNCTION materialize_query(table_ text, sql text) RETURNS void
|
|
| 1553 | 1553 |
LANGUAGE sql |
| 1554 | 1554 |
AS $_$ |
| 1555 | 1555 |
SELECT util.create_if_not_exists($$CREATE TABLE $$||quote_ident($1)||$$ AS |
| ... | ... | |
| 1558 | 1558 |
|
| 1559 | 1559 |
|
| 1560 | 1560 |
-- |
| 1561 |
-- Name: FUNCTION materialize_query(view_ text, sql text); Type: COMMENT; Schema: util; Owner: -
|
|
| 1561 |
-- Name: FUNCTION materialize_query(table_ text, sql text); Type: COMMENT; Schema: util; Owner: -
|
|
| 1562 | 1562 |
-- |
| 1563 | 1563 |
|
| 1564 |
COMMENT ON FUNCTION materialize_query(view_ text, sql text) IS 'idempotent';
|
|
| 1564 |
COMMENT ON FUNCTION materialize_query(table_ text, sql text) IS 'idempotent';
|
|
| 1565 | 1565 |
|
| 1566 | 1566 |
|
| 1567 | 1567 |
-- |
Also available in: Unified diff
fix: schemas/util.sql: materialize_query(): 1st param should be named table_, not view_