Re: Work Around For Oracle Feature - Mailing list pgsql-general

From Doug McNaught
Subject Re: Work Around For Oracle Feature
Date
Msg-id m3u1s5ziyg.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: Work Around For Oracle Feature  ("Kelly McTiernan" <kelly.mctiernan@verizon.net>)
List pgsql-general
"Kelly McTiernan" <kelly.mctiernan@verizon.net> writes:

> 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);
>
> fails in a JDBC call (JBoss JDBC Driver).  I wound up having to do =>

"Fails".  What's the error message you get?  That kind of query works
fine in general.  Have you tried the same query in 'psql' to see if it
works there?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: About functions
Next
From: Doug McNaught
Date:
Subject: Re: help with getting index scan