Revision 12471
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1070 | 1070 |
FROM $$||$1||$$ left_ |
| 1071 | 1071 |
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_ |
| 1072 | 1072 |
$$||util._if($4, ''::text, |
| 1073 |
$$ON left_::$$||util.typeof($3)||$$ %== right_::$$||util.typeof($3)||$$ |
|
| 1074 |
-- refer to EXPLAIN output for expansion of %== |
|
| 1073 |
$$ON left_ %== right_ -- refer to EXPLAIN output for expansion of %== |
|
| 1075 | 1074 |
$$)|| |
| 1076 |
$$WHERE left_::$$||util.typeof($3)||$$ IS DISTINCT FROM right_::$$||util.typeof($3)||$$
|
|
| 1075 |
$$WHERE left_ IS DISTINCT FROM right_
|
|
| 1077 | 1076 |
ORDER BY left_, right_ |
| 1078 | 1077 |
$$, $3) |
| 1079 | 1078 |
; |
Also available in: Unified diff
schemas/util.sql: diff(text, text): removed unnecessary casts to the base type in the join condition and the WHERE filter. these had been presumed necessary due to errors, but the errors turned out to be caused by the operator not being in the search_path. note that the casts in the columns list are still needed, as described in the associated comment.