Home > mailing lists

Question - Mailing list pgsql-general

From	Robert Partyka
Subject	Question
Date	October 14, 2003 16:22:16
Msg-id	3F8AA0DC.4060305@wdg.pl Whole thread Raw
Responses	Re: Question Re: Question
List	pgsql-general

Tree view

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

pgsql-general by date:

From: charette@writeme.com (Stephane Charette)
Date: 14 October 2003, 16:22:11
Subject: CREATE INDEX question (how to index on "money" field?)

From: "B.W.H. van Beest"
Date: 14 October 2003, 16:22:19
Subject: How to list which tables are available?

Question - Mailing list pgsql-general

Previous

Next