Revision 12494
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
2361 | 2361 |
|
2362 | 2362 |
|
2363 | 2363 |
-- |
2364 |
-- Name: prepend_comment(regclass, text); Type: FUNCTION; Schema: util; Owner: - |
|
2365 |
-- |
|
2366 |
|
|
2367 |
CREATE FUNCTION prepend_comment(table_ regclass, comment text) RETURNS void |
|
2368 |
LANGUAGE sql |
|
2369 |
AS $_$ |
|
2370 |
SELECT util.set_comment($1, concat($2, util.comment($1))) |
|
2371 |
$_$; |
|
2372 |
|
|
2373 |
|
|
2374 |
-- |
|
2375 |
-- Name: FUNCTION prepend_comment(table_ regclass, comment text); Type: COMMENT; Schema: util; Owner: - |
|
2376 |
-- |
|
2377 |
|
|
2378 |
COMMENT ON FUNCTION prepend_comment(table_ regclass, comment text) IS ' |
|
2379 |
comment: must start and end with a newline |
|
2380 |
'; |
|
2381 |
|
|
2382 |
|
|
2383 |
-- |
|
2364 | 2384 |
-- Name: qual_name(text[]); Type: FUNCTION; Schema: util; Owner: - |
2365 | 2385 |
-- |
2366 | 2386 |
|
Also available in: Unified diff
schemas/util.sql: added prepend_comment()