Re: lower() not working correctly...?

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.