> your using table.attrib like '%' to match everything except nulls
> 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.
GPG-Key available at http://www.sayegh.de
(see http://www.gnupg.org for details)
In response to
pgsql-novice by date
|Next:||From: Orlando Eloy Gentil||Date: 2001-01-17 11:04:11|
|Subject: Problems with authentication|
|Previous:||From: Tom Lane||Date: 2001-01-17 04:56:39|
|Subject: Re: log file? |