Revision 12462
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1072 | 1072 |
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_ |
| 1073 | 1073 |
$$||util._if($4, ''::text, |
| 1074 | 1074 |
$$ON left_::$$||util.typeof($3)||$$ %== right_::$$||util.typeof($3)||$$ |
| 1075 |
-- refer to EXPLAIN output for expansion of %== |
|
| 1075 | 1076 |
$$)|| |
| 1076 | 1077 |
$$WHERE left_::$$||util.typeof($3)||$$ IS DISTINCT FROM right_::$$||util.typeof($3)||$$ |
| 1077 | 1078 |
ORDER BY left_, right_ |
Also available in: Unified diff
schemas/util.sql: diff(text, text): in the outputted FULL JOIN query, documented that you should refer to the EXPLAIN output for the expansion of %==