pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtext 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