subselect return in where clause

From: Michael Hostbaek <mich(at)the-lab(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: subselect return in where clause
Date: 2003-01-28 11:21:23
Message-ID: 20030128112123.GC67742@mich2.itxmarket.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 /*

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2003-01-28 11:58:15 Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1
Previous Message Bhuvan A 2003-01-28 11:16:16 Re: converting microsoft sql server 2000 sql-code for postgresql