From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | Dev <dev(at)umpa-us(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: left outer join issue? |
Date: | 2004-05-18 19:17:04 |
Message-ID: | 20040518191704.GA2870@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 18, 2004 at 14:26:18 -0400,
Dev <dev(at)umpa-us(dot)com> wrote:
> At 02:28 PM 5/18/2004, Bruno Wolff III wrote:
> >On Tue, May 18, 2004 at 14:10:04 -0400,
> > Dev <dev(at)umpa-us(dot)com> wrote:
> >>
> >> Hello all,
> >>
> >> I need to do a left out join where a.field1 ilike %b.field2%
> >>
> >> But I can not figure out the exact syntax to using the ilike in the join?
> >
> >Use the ON clause syntax.
>
> Here is what it actually looks like
> LEFT OUTER JOIN table4 AS d ON (a.field1 ilike "%d.field2%") )
>
> a is setup for table1 and it is reference in a few other left outer joins.
>
> Those "other" outer joins work fine with out this new part
Maybe this isn't really an left join syntax question as much as
an expression syntax question. Maybe you want:
LEFT OUTER JOIN table4 AS d ON (a.field1 ilike ('%' || d.field2|| '%') )
From | Date | Subject | |
---|---|---|---|
Next Message | Keary Suska | 2004-05-18 19:26:17 | Re: left outer join issue? |
Previous Message | Mike Rylander | 2004-05-18 19:07:15 | Re: left outer join issue? |