Re: Question

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Robert Partyka <bobson(at)wdg(dot)pl>
Subject: Re: Question
Date: 2003-10-14 17:53:48
Message-ID: 3F8C382C.3010303@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert Partyka wrote:

> Hi,
>
> I have question:
>
> why such condition:
> foofield not like '%bar%'
>
> where foofield is varchar
>
> returns false (or rather even ignore row) on record where foofield is null
> but
> returns true on records where foofield is '' (empty string)

SQL specifications.

Empty string and NULL are two different thinks.

Regards
Gaetano Mendola

In response to

  • Question at 2003-10-13 12:55:56 from Robert Partyka

Browse pgsql-general by date

  From Date Subject
Next Message Network Administrator 2003-10-14 18:12:05 Re: previous & next buttons
Previous Message Richard Huxton 2003-10-14 17:47:08 Re: Excute comnands OS from plpgsql