Hello || isn't OR!!
testdb011=> select 'aaaa'||'bbbbbbb'; ?column? ------------- aaaabbbbbbb This is SQL, not java or C. OR is OR in SQL :-> Pavel On Thu, 11 Sep 2003, [ISO-8859-1] Alexander Blüm wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
