From: | Keary Suska <hierophant(at)pcisys(dot)net> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: left outer join issue? |
Date: | 2004-05-18 19:26:17 |
Message-ID: | BCCFBF79.10FAE%hierophant@pcisys.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
on 5/18/04 12:26 PM, dev(at)umpa-us(dot)com purportedly said:
> 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
Your field reference is incorrect. Use concatenation:
ON (a.field1 ilike '%'||d.field2||'%') )
Remember in Postgres, double quotes are only used to delimit identifiers.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Bottner | 2004-05-18 20:05:20 | Re: Help! Error Compiling |
Previous Message | Bruno Wolff III | 2004-05-18 19:17:04 | Re: left outer join issue? |