Revision 12479
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1060 | 1060 |
-- need util.%== as default/fallback |
| 1061 | 1061 |
|
| 1062 | 1062 |
RETURN QUERY |
| 1063 |
SELECT * FROM |
|
| 1064 |
util.eval2col_pair($$ |
|
| 1065 |
SELECT |
|
| 1066 |
/* need to explicitly cast each side to the return type because this does not |
|
| 1063 |
SELECT * FROM util.eval2col_pair(util.mk_diff_query($1, $2, $4, |
|
| 1064 |
$$/* need to explicitly cast each side to the return type because this does not |
|
| 1067 | 1065 |
happen automatically even when an implicit cast is available */ |
| 1068 |
left_::$$||util.typeof($3)||$$, right_::$$||util.typeof($3)||$$ |
|
| 1069 |
FROM |
|
| 1070 |
( |
|
| 1071 |
$$||util.mk_diff_query($1, $2, $4) |
|
| 1072 |
||$$) s |
|
| 1073 |
$$, $3) |
|
| 1066 |
left_::$$||util.typeof($3)||$$ |
|
| 1067 |
, right_::$$||util.typeof($3) |
|
| 1068 |
), $3) |
|
| 1074 | 1069 |
; |
| 1075 | 1070 |
END; |
| 1076 | 1071 |
$_$; |
Also available in: Unified diff
schemas/util.sql: diff(text, text): use mk_diff_query()'s new cols param to avoid a nested SELECT