Andreas Joseph Krogh a ecrit le 15/09/2006 10:06:
> I have the following query:
>
> select lower(firstname) || ' ' || lower(lastname) from person
>
> firstname and lastname are VARCHAR
>
> lower() returns NULL when firstname OR lastname is NULL, is this correct?
>
> This is 8.2devel from 24.08.2006.
>
NULL is an unkown value. lower of an unkown value is unknown... thus
NULL. This is correct behavior.
--
Guillaume.