Actually, I corrected myself. PostgreSQL *does* support subqueries.
Here is an online book that might
help:http://www.postgresql.org/docs/awbook.html.
-vince
On Thu, 26 Oct 2000, you wrote:
> I just looked and it doesn't look like PostgreSQL supports nested queries
> (someone else correct me if I am wrong). I am sure that MySQL doesn't.
>
> Given that, here are my suggestion:
>
> Perhaps you could get the same sort of affect by using a stored procedure
> language. PostgreSQL does support several different languages.
>
> Oracle and DB2 can be downloaded (I think for free, if not then it is very
> cheap) for development only. These definitely support nested queries. If you
> want to deploy with them you will have to pay (hefty) license fees. These can
> also be difficult to install.
>
> The only alternative is to rewrite your queries so that subselects aren't
> necessary. This should be doable, with a possible performance hit.
>
> On Thu, 26 Oct 2000, you wrote:
> > Have you anyone to suggest me?
> > I need a free database that allows concurrent access and nested sql
> > statements!!!
> > I tried InstantDB...but it doesn't allow concurrent access.
> > I tried Hypersonic and mySQL...but they don't allow nested sql statements.
> >
> > Where do I have to beat my head?
> > Paolo.
> >
> > ----- Original Message -----
> > From: "Daniel Schulze" <[EMAIL PROTECTED]>
> > To: "jBoss" <[EMAIL PROTECTED]>
> > Sent: Thursday, October 26, 2000 3:23 PM
> > Subject: Re: [jBoss-User] SQL statements
> >
> >
> > > > Has anyone any suggestions?
> > >
> > > Use another database ;-)
> > >
> > > \Daniel
> > >
> > >
> > > --
> > > --------------------------------------------------------------
> > > To subscribe: [EMAIL PROTECTED]
> > > To unsubscribe: [EMAIL PROTECTED]
> > > Problems?: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
> --
> _______________________
> Vincent Sheffer
> Director of Operations
> Telkel, Inc.
> _______________________
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
_______________________
Vincent Sheffer
Director of Operations
Telkel, Inc.
_______________________
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
