Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org (8.8.8/8.7.5) with ESMTP id WAA01243 for ; Fri, 5 Jun 1998 22:51:17 -0400 (EDT) Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by trends.net (8.8.8/8.8.8) with ESMTP id TAA12729 for ; Fri, 5 Jun 1998 19:13:25 -0400 (EDT) Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id SAA25524 for ; Fri, 5 Jun 1998 18:10:57 -0500 (CDT) Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id SAA24926 for pgsql-sql@postgresql.org; Fri, 5 Jun 1998 18:10:57 -0500 (CDT) From: Leslie Mikesell Message-Id: <199806052310.SAA24926@Venus.mcs.net> Subject: text concat in WHERE? To: pgsql-sql@postgreSQL.org Date: Fri, 5 Jun 1998 18:10:57 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text Should I be able to: 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