Project

General

Profile

« Previous | Next » 

Revision 12181

schemas/util.sql: added eval2col_pair()

View differences:

trunk/schemas/util.sql
1046 1046

  
1047 1047

  
1048 1048
--
1049
-- Name: eval2col_pair(text, anyelement); Type: FUNCTION; Schema: util; Owner: -
1050
--
1051

  
1052
CREATE FUNCTION eval2col_pair(sql text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record
1053
    LANGUAGE plpgsql
1054
    AS $$
1055
BEGIN
1056
	RAISE NOTICE '%', sql;
1057
	RETURN QUERY EXECUTE sql;
1058
END;
1059
$$;
1060

  
1061

  
1062
--
1063
-- Name: FUNCTION eval2col_pair(sql text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -
1064
--
1065

  
1066
COMMENT ON FUNCTION eval2col_pair(sql text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS 'col_type_null (*required*): NULL::col_type';
1067

  
1068

  
1069
--
1049 1070
-- Name: eval2set(text, anyelement); Type: FUNCTION; Schema: util; Owner: -
1050 1071
--
1051 1072

  

Also available in: Unified diff