Project

General

Profile

« Previous | Next » 

Revision 12299

schemas/util.sql: diff(text, text): implemented the single_row feature

View differences:

trunk/schemas/util.sql
966 966
/* need to explicitly cast each side to the return type because this does not
967 967
happen automatically even when an implicit cast is available */
968 968
SELECT left_::$$||pg_typeof($3)||$$, right_::$$||pg_typeof($3)||$$
969
FROM      $$||$1||$$ left_
970
FULL JOIN $$||$2||$$ right_
971
ON left_ = right_
969
FROM $$||$1||$$ left_
970
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_
971
$$||util._if($4, ''::text,
972
$$ON left_ = right_
972 973
WHERE left_ IS DISTINCT FROM right_
973 974
ORDER BY left_, right_
974
$$, $3)
975
$$), $3)
975 976
$_$;
976 977

  
977 978

  
......
981 982

  
982 983
COMMENT ON FUNCTION diff(left_ text, right_ text, col_type_null anyelement, single_row boolean, OUT left_ anyelement, OUT right_ anyelement) IS '
983 984
col_type_null (*required*): NULL::col_type
985
single_row: whether the tables consist of a single row, which should be
986
	displayed side-by-side
984 987

  
985 988
to run EXPLAIN on the FULL JOIN query:
986 989
# run this function

Also available in: Unified diff