Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Which is not supposted to list NULLS is listing - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Query Which is not supposted to list NULLS is listing
Date
Msg-id 20030527125026.GC2967@libertyrms.info
Whole thread Raw
In response to Re: Query Which is not supposted to list NULLS is listing  ("shreedhar" <shreedhar@lucidindia.net>)
List pgsql-general
Tree view 
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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-general by date:

Previous
From: "Yudha Setiawan"
Date:
Subject: Clustering using dblink
Next
From: "Eric Anderson Vianet SAO"
Date:
Subject: Re: PostgreSQL 7.3.1 on WinXP