Re: Query Which is not supposted to list NULLS is listing

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: Postgre General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query Which is not supposted to list NULLS is listing
Date: 2003-05-27 12:50:26
Message-ID: 20030527125026.GC2967@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 27, 2003 at 02:13:55PM +0530, shreedhar wrote:
> Hello,
>
> I am attaching an output with this mail. I am sure that I am not inserting
> '' for jobcomments in any case.

Please note that '' is not null. It's an empty string. Oracle gets
this wrong, so if you're used to the Oracle syntax, that might be
your problem.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Eric Anderson Vianet SAO 2003-05-27 13:13:34 Re: PostgreSQL 7.3.1 on WinXP
Previous Message Yudha Setiawan 2003-05-27 12:36:43 Clustering using dblink