Re: fyi

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: maillist <maillist(at)tnss(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: fyi
Date: 2003-08-01 05:53:52
Message-ID: 20030731225212.B37793-100000@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 31 Jul 2003, maillist wrote:

> select * from apps where (not apppag = null);
> returns nothing when it should return every thing

No. It should return nothing. apppag = null returns unknown for every
row. Use IS NULL to test if a value is null.

In response to

  • fyi at 2003-08-01 04:54:11 from maillist

Responses

  • Re: fyi at 2003-08-01 06:16:39 from maillist

Browse pgsql-admin by date

  From Date Subject
Next Message Mauri Sahlberg 2003-08-01 05:56:10 Re: Parallel transactions failing oddly
Previous Message Stephan Szabo 2003-08-01 05:51:40 Re: Parallel transactions failing oddly