Project

General

Profile

« Previous | Next » 

Revision 8084

schemas/functions.sql: Added col_global_names()

View differences:

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