Re: [SQL] search and replace

2004-06-13 Thread Benoît BOURNON
I do not try, may be it exists different languages to make this in postgresql : I make this in pl/pgsql, I do not have time to make this in C, CREATE OR REPLACE FUNCTION "_replaceblock" (text, text, text) RETURNS text AS' DECLARE  text_begin ALIAS FOR $1 ;  key_name ALIAS FOR $2 ;  key_val

Re: [SQL] sum ( time) problem

2004-06-13 Thread Willem de Jong
I'm afraid it is the only solution... Thanks for reply [EMAIL PROTECTED] (Bruno Wolff III) wrote in news:20040601140334.GA24188 @wolff.to: > On Thu, May 27, 2004 at 11:14:58 +, > Willem de Jong <[EMAIL PROTECTED]> wrote: >> >> >> >> If i do a sum(time) the result is like this '1 day 18:00: