pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
text concat in WHERE?
2+ messages / 2 participants
[nested] [flat]

* text concat in WHERE?
@ 1998-06-05 23:10 Leslie Mikesell <les@Mcs.Net>
  1998-06-09 16:09 ` Re: [SQL] text concat in WHERE? Jose' Soares Da Silva <sferac@bo.nettuno.it>
  0 siblings, 1 reply; 2+ messages in thread

From: Leslie Mikesell @ 1998-06-05 23:10 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] text concat in WHERE?
  1998-06-05 23:10 text concat in WHERE? Leslie Mikesell <les@Mcs.Net>
@ 1998-06-09 16:09 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>
  0 siblings, 0 replies; 2+ messages in thread

From: Jose' Soares Da Silva @ 1998-06-09 16:09 UTC (permalink / raw)
  To: Leslie Mikesell <les@Mcs.Net>; +Cc: pgsql-sql

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'




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1998-06-09 16:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-06-05 23:10 text concat in WHERE? Leslie Mikesell <les@Mcs.Net>
1998-06-09 16:09 ` Jose' Soares Da Silva <sferac@bo.nettuno.it>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox