Postgres Pro
Downloads
Home   >   mailing lists

subselect return in where clause - Mailing list pgsql-sql

From Michael Hostbaek
Subject subselect return in where clause
Date
Msg-id 20030128112123.GC67742@mich2.itxmarket.com
Whole thread Raw
Responses Re: subselect return in where clause  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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 /*

pgsql-sql by date:

Previous
From: Bhuvan A
Date:
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
Next
From: Geraint Jones
Date:
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1