From: Guillaume Lelarge <guillaume@lelarge.info>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-sql@postgresql.org
Subject: Re: lower() not working correctly...?
Date: Fri, 15 Sep 2006 10:44:22 +0200
Message-ID: <450A67E6.9070407@lelarge.info> (raw)
In-Reply-To: <200609151006.40801.andreak@officenet.no>
References: <200609151006.40801.andreak@officenet.no>
Andreas Joseph Krogh a ecrit le 15/09/2006 10:06:
> 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.
>
NULL is an unkown value. lower of an unkown value is unknown... thus
NULL. This is correct behavior.
--
Guillaume.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guillaume@lelarge.info, andreak@officenet.no
Subject: Re: lower() not working correctly...?
In-Reply-To: <450A67E6.9070407@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox