Re: Why isn't that null

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