Re: Diff/Patch integration -> SQL cvs clone

Jean-Michel POURE writes:

> Did anyone think of integrating diff/patch within PostgreSQL?

CREATE OR REPLACE FUNCTION diff(text, text) RETURNS text AS '
#!/bin/sh
echo "$1" > /tmp/$$-one
echo "$2" > /tmp/$$-two
diff -c /tmp/$$-one /tmp/$$-two
echo ""
rm -f /tmp/$$-one /tmp/$$-two
' LANGUAGE plsh;

peter=> \t\a
peter=> select diff('one\ntwo\nthree\n', 'one\nfive\nthree\n');

*** /tmp/17580-one Sun Nov 11 16:09:08 2001
--- /tmp/17580-two Sun Nov 11 16:09:08 2001
***************
*** 1,4 ****
one
! two
three

--- 1,4 ----
one
! five
three

patch() is left as an exercise. ;-)

--
Peter Eisentraut peter_e(at)gmx(dot)net