Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group