| From: | Andreas Joseph Krogh <andreak(at)officenet(dot)no> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | lower() not working correctly...? |
| Date: | 2006-09-15 07:52:53 |
| Message-ID: | 200609150952.53956.andreak@officenet.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
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 <andreak(at)officenet(dot)no>
Senior Software Developer / Manager
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
------------------------+---------------------------------------------+
OfficeNet AS | The most difficult thing in the world is to |
Karenslyst Allé 11 | know how to do a thing and to watch |
PO. Box 529 Skøyen | somebody else doing it wrong, without |
0214 Oslo | comment. |
NORWAY | |
Mobile: +47 909 56 963 | |
------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2006-09-15 08:07:43 | Wrong list, sorry (was: lower() not working correctly...?) |
| Previous Message | Pavel Stehule | 2006-09-15 07:31:17 | Re: plpgsql, return can contains any expression |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2006-09-15 08:06:40 | lower() not working correctly...? |
| Previous Message | Niklas Johansson | 2006-09-15 01:24:29 | Re: nested select within a DISCTINCT block |