Postgres Pro
Downloads
Home   >   mailing lists

query-question - Mailing list pgsql-general

From Alexander Blüm
Subject query-question
Date
Msg-id 3F605E4A.1020408@gmx.de
Whole thread Raw
Responses Re: query-question  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Re: query-question  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: query-question  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: query-question  (Holger Marzen <holger@marzen.de>)
List pgsql-general
Tree view 
hello,

I'm facing an odd problem.
I have a query:

SELECT "Kürzel", "Autor(en)", "Titel"
FROM "tblTitelangaben"
WHERE "Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)" ILIKE '%er%';

this works like a charm.

but if I add another ||"something" - which might be emtpy, I get no
results.. why?

WHERE
"Titel"||"Kürzel"||"Monographie-Kürzel"||"Autor(en)"||"Herausgeber"
ILIKE '%er%';

|| is the same as "OR", is it not?

1 OR 0 = 1
1 OR 1 = 1
0 OR 0 = 0
right?
therefore I should get the same, or more results...

any hints are greatly appreciated!

TIA,
alex

pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: I need a SQL...
Next
From: Pavel Stehule
Date:
Subject: Re: query-question