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]
