select in a LIKE?

From: "Arsalan Zaidi" <azaidi(at)directi(dot)com>
To: "PostgreSQL" <pgsql-interfaces(at)postgresql(dot)org>
Subject: select in a LIKE?
Date: 2001-10-03 07:40:43
Message-ID: 006101c14bde$b6f1b000$4301a8c0@directi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi

Can I construct a LIKE out of a select query? Something like

select * from users where name like '%(select name from blah)'

Currently, this won't work.

--Arsalan
-------------------------------------------------
WAR IS PEACE
FREEDOM IS SLAVERY
IGNORANCE IS STRENGTH
--1984

Browse pgsql-interfaces by date

  From Date Subject
Next Message Dave Page 2001-10-03 12:56:27 Re: select in a LIKE?
Previous Message Arsalan Zaidi 2001-10-03 07:13:12 java.lang.OutOfMemory Exception with a large number of inserts