Received: from proxy.bazzanese.com (sferac@ip230.tol11.interbusiness.it [195.120.106.230]) by hub.org (8.8.8/8.7.5) with ESMTP id KAA25078 for ; Tue, 9 Jun 1998 10:15:35 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id QAA03659; Tue, 9 Jun 1998 16:09:10 GMT Date: Tue, 9 Jun 1998 16:09:09 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Leslie Mikesell cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] text concat in WHERE? In-Reply-To: <199806052310.SAA24926@Venus.mcs.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Fri, 5 Jun 1998, Leslie Mikesell wrote: > Should I be able to: > SELECT * from t1, t2 > WHERE t1.a || ' ' || t2.b = t2.c; > Try this: SELECT * from t1, t2 WHERE (t1.a || ' ') || t2.b = t2.c; > In other words, combine two fields from one table and a constant space > for the join with a single field in the other table? > > Les Mikesell > les@mcs.com Ciao, Jose'