using output of a subselect in LIKE/ILIKE - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject using output of a subselect in LIKE/ILIKE
Date
Msg-id 3CB597EC.6AE67F76@trade-india.com
Whole thread Raw
Responses Re: using output of a subselect in LIKE/ILIKE  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Hi  folks, <p>I need to do something like : <p><tt>SELECT  branch from  branches</tt><br /><tt>where outstation
like</tt><br/><tt>SELECT  city from users  join personal_account_details</tt><br /><tt>using(userid)  where
email='ratans@cal.vsnl.com'</tt><tt></tt><p>Theabove does not work for obvious reasons , but can anyone help me <br
/>withthe right SQL? <br />  <p>regds <br />Rajesh Kumar Mallah. <br />  <br />  <br />  

pgsql-sql by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: REPOST: Trouble with SQL conversion
Next
From: "Richard Ellerbrock"
Date:
Subject: Re: REPOST: Trouble with SQL conversion