text concat in WHERE?
Leslie Mikesell <les@mcs.net>
From: Leslie Mikesell <les@Mcs.Net>
To: pgsql-sql@postgreSQL.org
Date: 1998-06-05T23:10:57Z
Lists: pgsql-sql
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