Revision 8084
Added by Aaron Marcuse-Kubitza almost 12 years ago
schemas/functions.sql | ||
---|---|---|
476 | 476 |
|
477 | 477 |
|
478 | 478 |
-- |
479 |
-- Name: col_global_names(regtype); Type: FUNCTION; Schema: functions; Owner: - |
|
480 |
-- |
|
481 |
|
|
482 |
CREATE FUNCTION col_global_names(type regtype, OUT name text, OUT global_name text) RETURNS SETOF record |
|
483 |
LANGUAGE plpgsql STABLE |
|
484 |
AS $$ |
|
485 |
DECLARE |
|
486 |
prefix text := functions.name(type)||'.'; |
|
487 |
BEGIN |
|
488 |
RETURN QUERY |
|
489 |
SELECT name_, prefix||name_ FROM functions.col_names(type) f (name_); |
|
490 |
END; |
|
491 |
$$; |
|
492 |
|
|
493 |
|
|
494 |
-- |
|
479 | 495 |
-- Name: col_names(regtype); Type: FUNCTION; Schema: functions; Owner: - |
480 | 496 |
-- |
481 | 497 |
|
Also available in: Unified diff
schemas/functions.sql: Added col_global_names()