Revision 12657
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1098 | 1098 |
$$ left_::$$||util.typeof($3)||$$ |
| 1099 | 1099 |
%== right_::$$||util.typeof($3)||$$ |
| 1100 | 1100 |
-- refer to EXPLAIN output for expansion of %==$$ |
| 1101 |
)), $3) |
|
| 1101 |
) |
|
| 1102 |
, $$ left_::$$||util.typeof($3)||$$ |
|
| 1103 |
IS DISTINCT FROM right_::$$||util.typeof($3) |
|
| 1104 |
), $3) |
|
| 1102 | 1105 |
; |
| 1103 | 1106 |
END; |
| 1104 | 1107 |
$_$; |
Also available in: Unified diff
bugfix: schemas/util.sql: diff(text, text): also need to cast left_/right_ to base type for the IS DISTINCT FROM filter, because the WHERE clause apparently does not use columns from the SELECT list, even though GROUP BY and ORDER BY do