X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 077AC9F9B55
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Sep 2006 05:32:10 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 21116-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Sep 2006 08:32:06 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from ns1.officenet.no (ns1.officenet.no [193.212.174.3])
	by postgresql.org (Postfix) with ESMTP id 444EE9FB232
	for <pgsql-sql@postgresql.org>; Fri, 15 Sep 2006 05:32:04 -0300 (ADT)
Received: from [80.203.71.244] (helo=[10.0.0.40])
	by ns1.officenet.no with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.60)
	(envelope-from <andreak@officenet.no>) id 1GO8im-0001Zg-DH
	for pgsql-sql@postgresql.org; Fri, 15 Sep 2006 10:06:50 +0200
From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: pgsql-sql@postgresql.org
Subject: lower() not working correctly...?
User-Agent: KMail/1.9.4
MIME-Version: 1.0
Content-Disposition: inline
X-Length: 1521
X-UID: 11246
Date: Fri, 15 Sep 2006 10:06:40 +0200
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200609151006.40801.andreak@officenet.no>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200609/102
X-Sequence-Number: 26313

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.

=2D-=20
Andreas Joseph Krogh <andreak@officenet.no>
Senior Software Developer / Manager
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
=2D-----------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Karenslyst All=E9 11      | know how to do a thing and to watch         |
PO. Box 529 Sk=F8yen      | somebody else doing it wrong, without       |
0214 Oslo               | comment.                                    |
NORWAY                  |                                             |
Mobile: +47 909  56 963 |                                             |
=2D-----------------------+---------------------------------------------+