Project

General

Profile

« Previous | Next » 

Revision 12308

bugfix: schemas/util.sql: diff(text, text): also need to include only different rows when comparing single-row tables

View differences:

trunk/schemas/util.sql
969 969
SELECT left_::$$||pg_typeof($3)||$$, right_::$$||pg_typeof($3)||$$
970 970
FROM $$||$1||$$ left_
971 971
$$||util._if($4, 'CROSS'::text, 'FULL')||$$ JOIN $$||$2||$$ right_
972
$$||util._if($4, ''::text,
973
$$ON left_ = right_
974
WHERE left_ IS DISTINCT FROM right_
972
$$||util._if($4, ''::text, $$ON left_ = right_
973
$$)||
974
$$WHERE left_ IS DISTINCT FROM right_
975 975
ORDER BY left_, right_
976
$$), $3)
976
$$, $3)
977 977
$_$;
978 978

  
979 979

  

Also available in: Unified diff