Revision 12278
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 930 | 930 |
AS $_$ |
| 931 | 931 |
SELECT * FROM |
| 932 | 932 |
util.eval2col_pair($$ |
| 933 |
SELECT * FROM
|
|
| 933 |
SELECT left_, right_ FROM
|
|
| 934 | 934 |
( |
| 935 | 935 |
$$||$1||$$ |
| 936 |
) left_ (left_)
|
|
| 936 |
) left_ |
|
| 937 | 937 |
FULL JOIN |
| 938 | 938 |
( |
| 939 | 939 |
$$||$2||$$ |
| 940 |
) right_ (right_)
|
|
| 940 |
) right_ |
|
| 941 | 941 |
ON left_ = right_ |
| 942 | 942 |
WHERE left_ IS DISTINCT FROM right_ |
| 943 | 943 |
ORDER BY left_, right_ |
Also available in: Unified diff
fix: schemas/util.sql: diff_cols(): don't assume that each side will have one column, as many of our validations queries have multiple columns