Hi,
As Karsten commented (I also found that problem yesterday), this patch might solve the problem...
Best regards, carlos
Index: gmMeasurements.sql =================================================================== RCS file: /cvsroot/gnumed/gnumed/gnumed/server/sql/gmMeasurements.sql,v retrieving revision 1.42 diff -u -r1.42 gmMeasurements.sql --- gmMeasurements.sql 14 May 2005 15:04:39 -0000 1.42 +++ gmMeasurements.sql 18 May 2005 12:32:17 -0000 @@ -259,7 +259,7 @@ alter table test_result alter column soap_cat set default 'o'; alter table test_result add constraint numval_needs_unit check ( - ((val_num is not null) and (trim(coalesce(val_unit, '') != ''))) + ((val_num is not null) and (trim(coalesce(val_unit, '')) != '')) or (val_num is null) );
_______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
