Revision 10594
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/util.sql | ||
---|---|---|
524 | 524 |
|
525 | 525 |
|
526 | 526 |
-- |
527 |
-- Name: added_cols(regclass, regclass); Type: FUNCTION; Schema: util; Owner: - |
|
528 |
-- |
|
529 |
|
|
530 |
CREATE FUNCTION added_cols(table_ regclass, names regclass) RETURNS SETOF text |
|
531 |
LANGUAGE sql STABLE STRICT |
|
532 |
AS $_$ |
|
533 |
SELECT util.derived_cols($1, $2) |
|
534 |
UNION |
|
535 |
SELECT util.eval2set($$ |
|
536 |
SELECT col |
|
537 |
FROM util.col_names($$||quote_nullable($1)||$$::regclass) f (col) |
|
538 |
JOIN $$||$2||$$ ON "to" = col |
|
539 |
WHERE "from" LIKE ':%' |
|
540 |
$$, NULL::text) |
|
541 |
$_$; |
|
542 |
|
|
543 |
|
|
544 |
-- |
|
545 |
-- Name: FUNCTION added_cols(table_ regclass, names regclass); Type: COMMENT; Schema: util; Owner: - |
|
546 |
-- |
|
547 |
|
|
548 |
COMMENT ON FUNCTION added_cols(table_ regclass, names regclass) IS 'gets table_''s added columns (all the columns not in the original data)'; |
|
549 |
|
|
550 |
|
|
551 |
-- |
|
527 | 552 |
-- Name: all_same_final(anyarray); Type: FUNCTION; Schema: util; Owner: - |
528 | 553 |
-- |
529 | 554 |
|
Also available in: Unified diff
schemas/util.sql: added added_cols()