Revision 12269
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2172 | 2172 |
CREATE FUNCTION save_drop_views(views text[]) RETURNS text |
| 2173 | 2173 |
LANGUAGE sql |
| 2174 | 2174 |
AS $_$ |
| 2175 |
SELECT concat(util.save_drop_view(unnest)) FROM unnest($1)
|
|
| 2175 |
SELECT string_agg(util.save_drop_view(unnest), '') FROM unnest($1)
|
|
| 2176 | 2176 |
$_$; |
| 2177 | 2177 |
|
| 2178 | 2178 |
|
| ... | ... | |
| 2477 | 2477 |
CREATE FUNCTION show_grants_for(table_ regclass) RETURNS text |
| 2478 | 2478 |
LANGUAGE sql STABLE |
| 2479 | 2479 |
AS $_$ |
| 2480 |
SELECT concat(cmd)
|
|
| 2480 |
SELECT string_agg(cmd, '')
|
|
| 2481 | 2481 |
FROM |
| 2482 | 2482 |
( |
| 2483 | 2483 |
SELECT (CASE WHEN has_table_privilege(user_, $1, 'SELECT') THEN |
Also available in: Unified diff
schemas/util.sql: use builtin string_agg(..., ) instead of concat()