Re: Work Around For Oracle Feature

From: Doug McNaught <doug(at)wireboard(dot)com>
To: "Kelly McTiernan" <kelly(dot)mctiernan(at)verizon(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Work Around For Oracle Feature
Date: 2002-02-25 15:20:39
Message-ID: m3u1s5ziyg.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Kelly McTiernan" <kelly(dot)mctiernan(at)verizon(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2002-02-25 15:22:06 Re: help with getting index scan
Previous Message Robert Treat 2002-02-25 15:12:07 Re: How do I make a query return all table names?