Revision 12236
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1718 | 1718 |
|
| 1719 | 1719 |
|
| 1720 | 1720 |
-- |
| 1721 |
-- Name: mk_search_path(text[]); Type: FUNCTION; Schema: util; Owner: - |
|
| 1722 |
-- |
|
| 1723 |
|
|
| 1724 |
CREATE FUNCTION mk_search_path(VARIADIC schemas text[]) RETURNS text |
|
| 1725 |
LANGUAGE sql IMMUTABLE |
|
| 1726 |
AS $_$ |
|
| 1727 |
SELECT string_agg(quote_ident(unnest), ', ') FROM unnest($1) |
|
| 1728 |
$_$; |
|
| 1729 |
|
|
| 1730 |
|
|
| 1731 |
-- |
|
| 1721 | 1732 |
-- Name: mk_source_col(regclass); Type: FUNCTION; Schema: util; Owner: - |
| 1722 | 1733 |
-- |
| 1723 | 1734 |
|
Also available in: Unified diff
schemas/util.sql: added mk_search_path()