MySQL does not support sub queries, cursors and transactions :-( There is a work around for each though ;-) T. Our Flash Site http://www.sanisoft-india.com Send a Gift to Nagpur - http://www.NagpurCity-e.com Email, Calendar, Coupons & Classifieds http://www.lifemadesimple.com -----Original Message----- From: ANAND RAMAN <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, September 28, 1999 6:18 PM Subject: Re: [LI] Postgre and mySQL comparison >more on this is also avaliable at >http://www.mysql.com/benchmark.html >Bye >Anand > >Gurunandan R Bhat wrote: > >> Check out the exhaustive perfomance/feature comparision of these and other >> databases at http://www.postgresql.org. >> >> > Postgresql turns out to be good if the database is big has lot of >> > integrety constraints ( primary key / foreign key ) which will become >> > difficult to implement in mysql. >> >> In fact, it might surprise you to know that PostgreSQL does *not* yet >> implement foriegn keys and referential integrity via native SQL. >> >> The nice thing about PostgreSQL is that it is extensible (since all >> catalogs including system catalogs are available for manipultion within >> your database). This implies that referential integrity can be implemented >> via your *own* C code using triggers or whatever else you think is the >> cool thing. In fact one such tutorial extension (spi/refint.c) is >> distributed with the sources and is a good guide for programmers wanting >> extra features. >> >> -------------------------------------------------------------------- >> For more information on Linux in India visit http://www.linux-india.org/ >> The Linux India mailing list does not accept postings in HTML format. > >-------------------------------------------------------------------- >For more information on Linux in India visit http://www.linux-india.org/ >The Linux India mailing list does not accept postings in HTML format. > -------------------------------------------------------------------- For more information on Linux in India visit http://www.linux-india.org/ The Linux India mailing list does not accept postings in HTML format.
