Revision 12185
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 919 | 919 |
COMMENT ON FUNCTION diff_cols(left_query text, right_query text, col_type_null anyelement, OUT left_ anyelement, OUT right_ anyelement) IS 'col_type_null (*required*): NULL::col_type |
| 920 | 920 |
usage: |
| 921 | 921 |
SELECT * FROM util.diff_cols($$VALUES (''1''), (''2''), (''4'')$$, $$VALUES (''1''), (''3''), (''4'')$$, NULL::text)
|
| 922 |
|
|
| 923 |
to run EXPLAIN on the FULL JOIN query: |
|
| 924 |
# run this function |
|
| 925 |
# look for a NOTICE containing the expanded query that it ran |
|
| 926 |
# run EXPLAIN on this expanded query |
|
| 922 | 927 |
'; |
| 923 | 928 |
|
| 924 | 929 |
|
Also available in: Unified diff
schemas/util.sql: diff_cols(): documented how to run EXPLAIN on the FULL JOIN query