Stored procedures (PL/pgSQL or C). Triggers. I can't remember if Mysql supports BLOBs or not, but Postgres does. Up until 4.x there wasn't any transaction support (Commit/Rollback) in Mysql.

Mike Norwood wrote:

What are some specific features that PostgreSQL has over MySQL. I keep hearing people say this, but wonder what specifically am I missing out on.

Thanks in advance.

Mike Norwood




On Thu, 3 Apr 2003, U. Jason Gloege Jr. wrote:





If, by "basics", you mean "the rudimentary storing and retrieving of data", then MySQL might be easier. But if you mean basics = "learning a standard set of features I would expect to find in other RDBMS suites", then I would probably go with Postgres... to the best of my knowledge, it's a little more feature-robust. MySQL is decent, I write against it every day at work, but Postgres has some things that we wish MySQL did, and I don't know that they've even been put into 4.x...




_______________________________________________
TriLUG mailing list
http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ:
http://www.trilug.org/~lovelace/faq/TriLUG-faq.html



_______________________________________________ TriLUG mailing list http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ: http://www.trilug.org/~lovelace/faq/TriLUG-faq.html

Reply via email to