erlug
[Top] [All Lists]

Re: [Erlug] select innestate in mysql

To: erlug@xxxxxxxxxxxxxx
Subject: Re: [Erlug] select innestate in mysql
From: Matteo Nastasi aka mop <nastasi@xxxxxxxxxxxxxxxxxxxx>
Date: Sat, 10 Aug 2002 15:18:05 +0200
On Sat, Aug 10, 2002 at 02:29:46PM +0200, Nando Santagata wrote:
> On Sat, Aug 10, 2002 at 01:17:27PM +0200, Ivan wrote:
> > select tx_id from tx where f in ( select f from f_pool where a < 5 )
> > la stessa query in mysql restutuisce l' arcano errore
> > ERROR 1064: You have an error in your SQL syntax near 'select f from
> > f_pool )' at line 1
> > come dire... "non supporti le select innestate?!?!" a.k.a. che cosa
> 
> E` cosi`.
> Ho sentito che le versioni piu` recenti dovrebbero supportare le query
> innestate, ma la versione distribuita con la woody ad esempio non lo fa.
Ecco una comparazione tra mysql (bleah!) e postgresql (yeah!) con in fondo
il plan di mysql.

http://www.mysql.com/doc/en/MySQL-PostgreSQL_features.html

Regards, mop.

-- 
 Matteo Nastasi  -  Milano - Italy  | HomePage: www.alternativeoutput.it
 Sostenere e supportare GNU/Linux ! | IRCnet:   #c-it   
 Milano Linux                       | E-Mail:   matteo.nastasi@xxxxxxxxx 
        Users Group  www.milug.org  |       nastasi@xxxxxxxxxxxxxxxxxxxx


<Prev in Thread] Current Thread [Next in Thread>