Re: Work Around For Oracle Feature

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(at)megazone23(dot)bigpanda(dot)com>
To: "Kelly McTiernan" <kelly(dot)mctiernan(at)verizon(dot)net>
Cc: <pgsql-general(at)postgresql(dot)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?
>
>
>