Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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 -- matthias(at)mteege(dot)de -- http://emugs.de
make world not war
PGP-Key auf Anfrage