[NTLUG:Discuss] MYSql vs. postgresql

MadHat madhat at unspecific.com
Sat Feb 22 09:45:43 CST 2003


On Fri, 2003-02-21 at 17:56, Terry Hancock wrote:
> On Friday 21 February 2003 09:41 am, Paul Ingendorf wrote:
> > Quoting David <david at hayes-family.org>:
> > >  * sub-queries, such as: SELECT * FROM SALES WHERE ITEM_COLOR IS IN
> > >    (SELECT COLOR FROM ....).  To do this in Mysql, you need to run
> > >    multiple queries and tie them together in your PHP or Perl script. 
> > 
> > I have always dealt with this using
> > select * from sales,otherdb where sales.item_color = otherdb.color
> > (Comming soon)
> > http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
> 
> Coming soon? Doesn't that work in v3.23?  Maybe I'm missing a subtlety here, 
> but I think I have code like this in my current project somewhere.  This is 
> really just an implicit join, isn't it?

Heis saying that is what he dones now.  the 'real' sub selects are
'coming soon'  check the page. ;)  Yes, the first method has been
supported for a while.

-- 
MadHat at Unspecific.com
`But I don't want to go among mad people,' Alice remarked.
`Oh, you can't help that,' said the Cat: `we're all mad here...'
   -- Lewis Carroll - _Alice's_Adventures_in_Wonderland_




More information about the Discuss mailing list