Revision 12490
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 3506 | 3506 |
|
| 3507 | 3507 |
|
| 3508 | 3508 |
-- |
| 3509 |
-- Name: use_own_schema(anyelement); Type: FUNCTION; Schema: util; Owner: -
|
|
| 3509 |
-- Name: use_schema(anyelement); Type: FUNCTION; Schema: util; Owner: - |
|
| 3510 | 3510 |
-- |
| 3511 | 3511 |
|
| 3512 |
CREATE FUNCTION use_own_schema(schema_anchor anyelement) RETURNS void
|
|
| 3512 |
CREATE FUNCTION use_schema(schema_anchor anyelement) RETURNS void |
|
| 3513 | 3513 |
LANGUAGE sql |
| 3514 | 3514 |
AS $_$ |
| 3515 | 3515 |
SELECT util.set_search_path(util.mk_search_path(util.schema($1))) |
| ... | ... | |
| 3517 | 3517 |
|
| 3518 | 3518 |
|
| 3519 | 3519 |
-- |
| 3520 |
-- Name: FUNCTION use_own_schema(schema_anchor anyelement); Type: COMMENT; Schema: util; Owner: -
|
|
| 3520 |
-- Name: FUNCTION use_schema(schema_anchor anyelement); Type: COMMENT; Schema: util; Owner: - |
|
| 3521 | 3521 |
-- |
| 3522 | 3522 |
|
| 3523 |
COMMENT ON FUNCTION use_own_schema(schema_anchor anyelement) IS '
|
|
| 3523 |
COMMENT ON FUNCTION use_schema(schema_anchor anyelement) IS ' |
|
| 3524 | 3524 |
auto-appends util to the search_path to enable use of util operators |
| 3525 | 3525 |
'; |
| 3526 | 3526 |
|
Also available in: Unified diff
schemas/util.sql: use_own_schema(): renamed to use_schema() because this can be used for any type-linked schema