Re: fairly current mysql v postgresql comparison need for

Mike Mascari <mascarm@mascari.com> writes:
> *They apparently added subselects as of Jan of this year in FROM
> and WHERE clauses. Docs don't mention target lists, they might
> have implemented subselects in target lists though.

It would be worth asking some hard questions about how good their
subselect implementation is, too.  "We've got subselects!" doesn't
mean that they can optimize 'em with any efficiency.  Our subselect
implementation has gotten a lot better over the years than it started
out as; I'd imagine MySQL is just starting to climb that same learning
curve ...

            regards, tom lane