Postgres Pro
Downloads
Home   >   mailing lists

text concat in WHERE? - Mailing list pgsql-sql

From Leslie Mikesell
Subject text concat in WHERE?
Date
Msg-id 199806052310.SAA24926@Venus.mcs.net
Whole thread Raw
Responses Re: [SQL] text concat in WHERE?  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Marc Howard Zuckman
Date:
Subject: Need help understanding unique indices
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] problems with CAST :-{