Revision 12308
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/schemas/util.sql | ||
---|---|---|
969 | 969 |
SELECT left_::$$||pg_typeof($3)||$$, right_::$$||pg_typeof($3)||$$ |
970 | 970 |
FROM $$||$1||$$ left_ |
971 | 971 |
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_ |
972 |
$$||util._if($4, ''::text, |
|
973 |
$$ON left_ = right_
|
|
974 |
WHERE left_ IS DISTINCT FROM right_ |
|
972 |
$$||util._if($4, ''::text, $$ON left_ = right_
|
|
973 |
$$)||
|
|
974 |
$$WHERE left_ IS DISTINCT FROM right_
|
|
975 | 975 |
ORDER BY left_, right_ |
976 |
$$), $3)
|
|
976 |
$$, $3) |
|
977 | 977 |
$_$; |
978 | 978 |
|
979 | 979 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: diff(text, text): also need to include only different rows when comparing single-row tables