Revision 12181
Added by Aaron Marcuse-Kubitza almost 11 years ago
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
schemas/util.sql: added eval2col_pair()