Re: select * from mytable where myfield=null;

From: "Hoanui Morangie" <hoanui(at)excite(dot)com>
To: marin(dot)dimitrov(at)sirma(dot)bg, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: select * from mytable where myfield=null;
Date: 2002-05-14 12:29:47
Message-ID: 20020514122947.2E949BF9B@xmxpita.excite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I need NULL value, some of these columns are foreign keys. And using dummy values is not good practice anyway.

Hoanui

--- On Tue 05/14, Marin Dimitrov wrote:
>
>
>
>
>
>
>
>
> style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
> BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
> ----- Original Message -----
> style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color:
> black">From:
> Hoanui
> Morangie
>
>
> Hi, I understand that this behavior is a standard but agree
> with
> Bruno that it's nonsense. I have trouble with it in my own application.
> I use
> sql command like "select * from A where A.a=? and A.b=? and A.c=? and
> A.d=?
> and A.e=?". There are five parameters in my query and each of them can
> be
> null! I can not create SQL command string for all possible combinations
> of
> null values so I have to build the query dynamically. Why then use
> prepared
> statement? I doubt that anybody ever needed x=null in SQL
> command but
> it seems that my example is very common. There SHOULD be some workaround
> for
> that. But I agree that this is not topic for this list.
>
>
>
> don't use NULLs - introduce a dummy value
> that bears the
> semantic of NULL so u can use "= XXX" instead of " is
> NULL"
>
> hth,
>
> Marin
>
> ----"...what you
> brought
> from your past, is of no use in your present. When you must choose a
> new
> path, do not bring old experiences with you. Those who strike out
> afresh,
> but who attempt to retain a little of the old life, end up torn apart
> by
> their own memories. "
>
>

------------------------------------------------
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hoanui Morangie 2002-05-14 12:30:22 Re: select * from mytable where myfield=null;
Previous Message ganaraj k 2002-05-14 10:21:07 enquiring