On 4 Sep 2009, at 15:47, Scott Frankel wrote:
Hello,
Is it possible to perform selects in a where clause of a statement?
Given a statement as follows:
SELECT foo.foo_id, foo.name
FROM foo, bar
WHERE foo.bar_id = bar.bar_id
AND bar.name = 'martini';
I've explored the "where exists" clause, but it's not supported by
the application toolkit I'm using. AFAIK, I've only got access to
where ...
Have you tried a view?
Is that some in-house toolkit you're using? If not, could you tell
what it is so that people can chime in with ways to use that toolkit
to get it do what you want or at least know what toolkit to avoid?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4aa1375011861997820494!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
