Re: Query with NULL

From: Mladen Gogala <>
Date: Thu, 31 Dec 2009 13:33:35 +0000 (UTC)
Message-ID: <hhi97f$ncu$>

On Wed, 30 Dec 2009 07:36:19 -0800, Mark D Powell wrote:

> Being that :wp18 and :wp19 are program bind variables then depending on
> which variables have a value they are actually 4 different conditions:
> return all rows when neither variable has a value, return matching rows
> for wp18 when wp19 is null,, return matching rows for wp19 when wp18 is
> null, and return only rows that match both wp18 and wp19 when both have
> a value.

Plus the fact that the job checking whether an external variable is null really belongs to the programming interface and not the database.

Received on Thu Dec 31 2009 - 07:33:35 CST

Original text of this message