At 01:18 PM 11/29/2003 -0500, Bruce Momjian wrote:
>Jason Tesser wrote:
>>
>> Quoted as gospel by various people:
>> >> MySQL cannot even handle sub-queries yet.
>>
>> > BTW, is that really still true? I thought they had at least some
>> > support for subqueries by now.
>>
>> yes sub queries in 4.1 which is still alpha
>
>Wow, they have subqueries in alpha. Guys, we better get going! :-)
I always got the impression that MySQL started out fast but stripped
down whereas Postgresql started out more featureful but slower. I think
as MySQL adds features from other RDBMS engines, the performance will
suffer; whereas Postgresql already has all the features and can work
more on optimization and performance impact. I think in the end this
will hurt MySQL as one of it's main selling points, performance, starts
to suffer and it wil lhelp Postgresql as all the features get faster and
more robust