Then the application need not append anything for blank search fields. It's
just complicating things.
----- Original Message -----
From: "Nabil Sayegh" <nsmail(at)sayegh(dot)de>
To: "rob" <rob(at)cabrion(dot)com>
Sent: Wednesday, January 17, 2001 5:48 AM
Subject: Re: LIKE optimization
> rob wrote:
> > your using table.attrib like '%' to match everything except nulls
> > right?
> > use table.attribute IS NOT NULL instead.
> No, it's the web interface to our hotel-db. People can search for eg.
> City but may leave this field blank.
> So % is always appended (sometimes also prepended).
> I didn't know that it doesn't match NULL, but fortunately the attributes
> are all NOT NULL.
> Nabil Sayegh
> GPG-Key available at http://www.sayegh.de
> (see http://www.gnupg.org for details)
In response to
pgsql-novice by date
|Next:||From: Nabil Sayegh||Date: 2001-01-17 14:46:38|
|Subject: Re: Re: LIKE optimization|
|Previous:||From: Paul Joseph McGee||Date: 2001-01-17 14:10:36|
|Subject: Type Creation|