On fös, 2006-09-15 at 09:52 +0200, Andreas Joseph Krogh wrote: > 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?
In fact, your problem has nothing to do with lower(). You probably did not expect the || operator to return NULL when any of the operands is NULL as seen in select firstname || ' ' || lastname from person so , as someone else has already mentioned, you should use coalesce. gnari ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
