Re: [JDBC] select * from mytable where myfield=null;

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [JDBC] select * from mytable where myfield=null;
Date: 2002-05-14 19:57:47
Message-ID: 20020514155747.J9748@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Tue, May 14, 2002 at 08:29:06AM -0700, Jeremy Buchmann wrote:
>
> select * from tablename where foo = null;

You can actually turn this back on if you really want --
TRANSFORM_NULL_EQUALS. See

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html#RUNTIME-CONFIG-GENERAL

(watch for long lines -- sorry). There are good reasons to avoid the
"foo = null" construction, BTW.

> But what about the isnull operator/keyword/whatever it is...
>
> select * from tablename where foo isnull;
>
> I use that on occasion (in 7.1.2)...did this change in 7.2 also?

It works fine.

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-05-14 21:16:41 Re: Spped of max
Previous Message Peter Darley 2002-05-14 19:45:54 Re: Using COPY

Browse pgsql-jdbc by date

  From Date Subject
Next Message Haug Bürger 2002-05-15 06:39:54 Re: insert blocking?
Previous Message Jeremy Buchmann 2002-05-14 18:21:53 Re: select * from mytable where myfield=null;