Project

General

Profile

« Previous | Next » 

Revision 12494

schemas/util.sql: added prepend_comment()

View differences:

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