Revision 12284
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 930 | 930 |
AS $_$ |
| 931 | 931 |
SELECT * FROM |
| 932 | 932 |
util.eval2col_pair($$ |
| 933 |
SELECT left_, right_ |
|
| 933 |
/* need to explicitly cast each side to the return type because this does not |
|
| 934 |
happen automatically even when an implicit cast is available */ |
|
| 935 |
SELECT left_::$$||pg_typeof($3)||$$, right_::$$||pg_typeof($3)||$$ |
|
| 934 | 936 |
FROM $$||$1||$$ left_ |
| 935 | 937 |
FULL JOIN $$||$2||$$ right_ |
| 936 | 938 |
ON left_ = right_ |
Also available in: Unified diff
bugfix: schemas/util.sql: diff(): need to explicitly cast each side to the return type because this does not happen automatically even when an implicit cast is available