[Pugged] mysql sub-query feature

Tim Perdue ciapug@ciapug.org
Mon, 02 Dec 2002 18:36:35 -0600


dave@visionary.com wrote:
  going to be adding sub queries in version 4.1.
> 
> http://www.mysql.com/products/mysql-4.0/index.html
> 
> That's probably the single feature I've been wanting the most. You can
> work around it, but the resulting SQL statements get pretty long and
> hard to read. Being able to do:
> 
> SELECT * FROM users WHERE id IN (SELECT id FROM stuff)
> 
> ..makes life a lot easier when you're dealing with parent-child
> relations.
> 
> I didn't see a release schedule. Version 4.0.x is in beta now, so I
> bet it will be at least another 6 months.

Yeah, frankly there's no real learning curve moving to postgres. You 
basically type psql instead of mysql at the command line, and then it's 
all pretty much the same from there on out.

You could learn it in < 5 minutes I'm sure.

Tim