Tom Lane <[EMAIL PROTECTED]> writes:

[...]

> > If I change the function statement as follows: 
> 
> > IF NEW.vkp = 0 THEN
> >    ... 
> > END IF;
> 
> > it works
> 
> Shouldn't that give a type error of some sort?  You didn't say
> what type vkp is, but if it's a string type then comparing it
> against a numeric shouldn't work IMHO.

no it isn't. It is a float8 type. I changed my program in
that way that the query includes NULL instead of ''.

Bis dann
Matthias


-- 
Matthias Teege -- [EMAIL PROTECTED] -- http://emugs.de
make world not war
PGP-Key auf Anfrage

Reply via email to