Peter, should plsh be added to our supplied server-side programming
languages? Seems like a major feature to me and to others as well.
---------------------------------------------------------------------------
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026