----- Original Message -----
From: Jean-Michel POURE <jm.poure@freesurf.fr>
Sent: Sunday, November 11, 2001 10:41 AM
> Fantastic. It is possible to provide wrappers around most utilities.
Which is not always portable and/or inconsistent, unfortunately;
depending on whether an OS you're running PG on has such utilities
and they behave all in the same way or not...
-s
> >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