Revision 12428
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1023 | 1023 |
-- Name: diff(text, text, anyelement, boolean); Type: FUNCTION; Schema: util; Owner: - |
| 1024 | 1024 |
-- |
| 1025 | 1025 |
|
| 1026 |
CREATE FUNCTION diff(left_ text, right_ text, col_type_null anyelement, single_row boolean DEFAULT false, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record
|
|
| 1026 |
CREATE FUNCTION diff(left__ text, right__ text, col_type_null anyelement, single_row boolean DEFAULT false, OUT left_ anyelement, OUT right_ anyelement) RETURNS SETOF record
|
|
| 1027 | 1027 |
LANGUAGE sql |
| 1028 | 1028 |
SET search_path TO util |
| 1029 | 1029 |
AS $_$ |
| ... | ... | |
| 1044 | 1044 |
|
| 1045 | 1045 |
|
| 1046 | 1046 |
-- |
| 1047 |
-- Name: FUNCTION diff(left_ text, right_ text, col_type_null anyelement, single_row boolean, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -
|
|
| 1047 |
-- Name: FUNCTION diff(left__ text, right__ text, col_type_null anyelement, single_row boolean, OUT left_ anyelement, OUT right_ anyelement); Type: COMMENT; Schema: util; Owner: -
|
|
| 1048 | 1048 |
-- |
| 1049 | 1049 |
|
| 1050 |
COMMENT ON FUNCTION diff(left_ text, right_ text, col_type_null anyelement, single_row boolean, OUT left_ anyelement, OUT right_ anyelement) IS '
|
|
| 1050 |
COMMENT ON FUNCTION diff(left__ text, right__ text, col_type_null anyelement, single_row boolean, OUT left_ anyelement, OUT right_ anyelement) IS '
|
|
| 1051 | 1051 |
col_type_null (*required*): NULL::col_type |
| 1052 | 1052 |
single_row: whether the tables consist of a single row, which should be |
| 1053 | 1053 |
displayed side-by-side |
Also available in: Unified diff
schemas/util.sql: diff(text, text): renamed IN params to be different from OUT params to support LANGUAGE plpgsql