Re: [HACKERS] lower() not working correctly...?

MAIL PROTECTED] Im Auftrag von Andreas Joseph Krogh Gesendet: Freitag, 15. September 2006 09:53 An: pgsql-hackers@postgresql.org Betreff: [HACKERS] lower() not working correctly...? I have the following query: select lower(firstname) || ' ' || lower(lastname) from person firstname and la

[HACKERS] lower() not working correctly...?

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. -- Andreas Joseph Krogh <[EMAIL PROTECTED]> Senior Software