Re: Diff/Patch integration -> SQL cvs clone

Hello Peter,

Fantastic. It is possible to provide wrappers around most utilities.
I am stuck down on my chair. Cannot believe it...

Cheers,
Jean-Michel POURE

At 16:40 11/11/01 +0100, you wrote:
>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