Received: from uno.tksoft.com (modem-10.copernicus.brandx.net [209.55.65.10]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA53164 for ; Mon, 26 Jul 1999 00:52:36 -0400 (EDT) (envelope-from tk@uno.tksoft.com) Received: (from tk@localhost) by uno.tksoft.com (8.8.8/8.8.8) id VAA30904; Sun, 25 Jul 1999 21:52:43 -0700 From: "tjk@tksoft.com" Message-Id: <199907260452.VAA30904@uno.tksoft.com> Subject: Re: [SQL] Expr Abbreviations/Functions? To: pgsql-sql@postgreSQL.org Date: Sun, 25 Jul 1999 21:52:42 -0700 (PDT) Cc: herouth@oumail.openu.ac.il In-Reply-To: from "Herouth Maoz" at Jul 25, 99 03:47:58 pm Content-Type: text Herouth, You're right. If I recall the original question correctly, the "only" real solution would seem to be to define a function to search the appropriate fields. Troy Troy Korjuslommi Tksoft OY, Inc. tjk@tksoft.com Software Development Open Source Solutions Hosting Services > > At 02:11 +0300 on 25/07/1999, tjk@tksoft.com wrote: > > > > You could merge the fields and search with : > > > > select * from tablex where lower(f1||f2||f3) ~ 'foo'; > > Nah. If f1 is 'Narf' and f2 is 'oodp', it will match... > > Herouth > > -- > Herouth Maoz, Internet developer. > Open University of Israel - Telem project > http://telem.openu.ac.il/~herutma > > > >