| From: | "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> |
|---|---|
| To: | "Andreas Joseph Krogh" <andreak(at)officenet(dot)no>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: lower() not working correctly...? |
| Date: | 2006-09-15 08:21:02 |
| Message-ID: | FA095C015271B64E99B197937712FD020E4B0CB0@freedom.grz.icomedias.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
This works as intended. Try this:
select coalesce(lower(firstname), '') || ' ' || coalesce(lower(lastname), '') from person
Concating something unknown (=NULL) and a string = unknown (=NULL)
-----Ursprüngliche Nachricht-----
Von: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-owner(at)postgresql(dot)org] Im Auftrag von Andreas Joseph Krogh
Gesendet: Freitag, 15. September 2006 09:53
An: pgsql-hackers(at)postgresql(dot)org
Betreff: [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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-09-15 08:59:03 | Re: Build v8.1.4 with VC++ 2005 |
| Previous Message | Andreas Joseph Krogh | 2006-09-15 08:07:43 | Wrong list, sorry (was: lower() not working correctly...?) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2006-09-15 08:44:22 | Re: lower() not working correctly...? |
| Previous Message | Andreas Joseph Krogh | 2006-09-15 08:06:40 | lower() not working correctly...? |