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@gmx.net