Question

From: Robert Partyka <bobson(at)wdg(dot)pl>
To: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Question
Date: 2003-10-13 12:55:56
Message-ID: 3F8AA0DC.4060305@wdg.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

regards
Robert

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas LeBlanc 2003-10-13 13:39:26 Re: Unique Index vs. Unique Constraint
Previous Message Anthony Agoro (C) 2003-10-13 12:30:22 Re: Postgres 7.3.4 install