Hi,
there might be a better solution out there, but it seemed like an interesting
problem so I wrote this function:
CREATE OR REPLACE FUNCTION stringdiff(text, text)
RETURNS TEXT
AS $$
SELECT array_to_string(ARRAY(
SELECT
CASE WHEN substring($1 FROM n FOR 1) = substring(
Can anyone give me a way to find the difference between two text
fields on a character by character basis. Essentially, I'd like to
logically AND the two together and for any position that has a
non-zero result show whatever character is in that position for the
second string. The solution can b
