My apologies. I don't know what I wac doing wrong, but when I tried coding
it for a second time, it worked just fine! I do still have a problem with
container managed transactions, but that's a JBoss issue (for that matter
Weblogic has similar issues). I can get around that one by setting
transaction not-supported, and doing my own commits. Thanks.
Kelly McTiernan
----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Kelly McTiernan" <kelly.mctiernan@verizon.net>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, February 25, 2002 8:20 AM
Subject: Re: [GENERAL] Work Around For Oracle Feature
> On Sat, 23 Feb 2002, Kelly McTiernan wrote:
>
> > Hi!
> > I've been unable to get nested queries to work. e.g:
> >
> > select x,y from z where y in (select r from t);
>
> What error do you get?
>
>
>
