Re: [PERFORM] Question about PGSQL functions

2007-03-08 Thread Steve
Steve wrote: IF strlen(source.corrected_procedure_code) THEN: summary.procedure_code=source.corrected_procedure_code summary.wrong_procedure_code=source.procedure_code ELSE: summary.procedure_code=source.procedure_code summary.wrong_procedure_code=NULL Um, so you test if source.correct

Re: [PERFORM] Question about PGSQL functions

2007-03-08 Thread Heikki Linnakangas
Steve wrote: IF strlen(source.corrected_procedure_code) THEN: summary.procedure_code=source.corrected_procedure_code summary.wrong_procedure_code=source.procedure_code ELSE: summary.procedure_code=source.procedure_code summary.wrong_procedure_code=NULL Um, so you test if source.correct

[PERFORM] Question about PGSQL functions

2007-03-08 Thread Steve
Hey there :) I'm re-writing a summarization process that used to be very 'back and forth' intensive (i.e. very chatty between my summarization software and the DB). I'm trying to reduce that by practically reducing all this back and forth to a single SQL query, but in order to support certain