Re: MySQL vs postgres

[Thai <dvt@xxxxxxxxxxxxxxxx>]

You can see a comparison among some SQL servers such as MySQL, PostgreSQL, M$SQL 7, Sybase, Oracle 8
... at www.postgresql.org. At first, I like MySQL much because many people use it and there are many
applications using it. Now I see that it doesn't support something (e.g nested subqueries), while
postgresql does. Now I don't know what I should choose. Does anybody give me a suggestion?

Richard Vincent wrote:

> Does anyone know the main difference between these two SQL implementations?
> (MySQL and Postgres) Because I've been studiing MySQL for about about three
> weeks now ... and I've come across a SQL construct that MySQL does not
> support ..... which is views ....... I know nothing about postgress but I'm
> wondering is postgres more SQL-92 compliant than MySQL? I really like MySQL
> but I want to stay with the most compliant SQL implementation (at least
> while I'm in process of learning SQL). Thank you.