From: Michael Hostbaek <mich@the-lab.org>
To: pgsql-sql@postgresql.org
Subject: subselect return in where clause
Date: Tue, 28 Jan 2003 12:21:23 +0100
Message-ID: <20030128112123.GC67742@mich2.itxmarket.com> (raw)
Group,
Is it possible to use a subselect result in a where statement ? If so,
how ?
Fx.
select some_stuff, more_stuff,
(select other_stuff from other_table where other_table.stuff ilike
stuff.match) as other_stuff from stuff where other_stuff = 'hello'
thanks.
--
Best Regards,
Michael Landin Hostbaek
FreeBSDCluster.org - an International Community
*/ PGP-key available upon request /*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mich@the-lab.org
Subject: Re: subselect return in where clause
In-Reply-To: <20030128112123.GC67742@mich2.itxmarket.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox