Re: Diff/Patch integration -> SQL cvs clone

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