Revision 12456
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1064 | 1064 |
RETURN QUERY |
| 1065 | 1065 |
SELECT * FROM |
| 1066 | 1066 |
util.eval2col_pair($$ |
| 1067 |
SELECT |
|
| 1067 | 1068 |
/* need to explicitly cast each side to the return type because this does not |
| 1068 | 1069 |
happen automatically even when an implicit cast is available */ |
| 1069 |
SELECT left_::$$||util.typeof($3)||$$, right_::$$||util.typeof($3)||$$
|
|
| 1070 |
left_::$$||util.typeof($3)||$$, right_::$$||util.typeof($3)||$$ |
|
| 1070 | 1071 |
FROM $$||$1||$$ left_ |
| 1071 | 1072 |
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_ |
| 1072 | 1073 |
$$||util._if($4, ''::text, |
Also available in: Unified diff
fix: schemas/util.sql: diff(text, text): FULL JOIN SELECT statement: don't put a comment at the very beginning, because this prevents it from being autoexplained (this is the query we particularly want EXPLAIN output for)