Re: [GENERAL] Differences between Postgres and MySql

2010-07-18 Thread Scott Marlowe
On Sun, Jul 18, 2010 at 2:13 PM, John Gage wrote: >> John Gage, 25.06.2010 11:50: >>> >>> I am astonished to discover that MySQL does not support >>> regular expressions much less something like tsvector. >> >> Getting really off-topic now: but MySQL does support Regex >> >> http://dev.mysql.com/d

[GENERAL] Differences between Postgres and MySql

2010-07-18 Thread John Gage
John Gage, 25.06.2010 11:50: I am astonished to discover that MySQL does not support regular expressions much less something like tsvector. Getting really off-topic now: but MySQL does support Regex http://dev.mysql.com/doc/refman/5.1/en/regexp.html I have done an extensive comparison betwee

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Mike Nolan
> Interesting you should say that, because for years we were getting beat > up regularly about how poor our ALTER capabilities were compared to > MySQL's. Have we really passed them up in ALTER flexibility? Or is > there some other limitation you are thinking of? I wasn't commenting on the flexi

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Tom Lane
Mike Nolan <[EMAIL PROTECTED]> writes: > MySQL's poor implementation of the 'alter table' process. Interesting you should say that, because for years we were getting beat up regularly about how poor our ALTER capabilities were compared to MySQL's. Have we really passed them up in ALTER flexibilit

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Robert Treat
On Wed, 2004-02-18 at 09:20, Mark Cubitt wrote: > cheers everybody for the help, I think I can do what I need with mysql, but > would much prefer postgres. > > > There's a little voice telling me this is a troll, but in case not > > a just another quick question, "troll" ??? > http://info.astri

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Mike Nolan
> the reason I ask is I have always used postgres at home and work, but my new > web host only has mysql :( Have you tried asking them to support postgreSQL? A client of mine had to switch ISP's rather abruptly last fall, in the middle of a lengthy project to convert them to postgreSQL from a le

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Mark Cubitt
cheers everybody for the help, I think I can do what I need with mysql, but would much prefer postgres. > There's a little voice telling me this is a troll, but in case not a just another quick question, "troll" ??? Thanks in advance Regards Mark Cubitt ---(end of bro

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Robert Treat
On Wed, 2004-02-18 at 06:50, Mark Cubitt wrote: > the reason I ask is I have always used postgres at home and work, but my new > web host only has mysql :( > > I want to know what sort of differences I will have in regards to > programming php/perl webpages using the database. > > I current use s

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Richard Huxton
On Wednesday 18 February 2004 11:50, Mark Cubitt wrote: > the reason I ask is I have always used postgres at home and work, but my > new web host only has mysql :( > > I want to know what sort of differences I will have in regards to > programming php/perl webpages using the database. Perhaps your

Re: [GENERAL] Differences between postgres and mysql

2004-02-18 Thread Paul Thomas
On 18/02/2004 11:50 Mark Cubitt wrote: the reason I ask is I have always used postgres at home and work, but my new web host only has mysql :( I want to know what sort of differences I will have in regards to programming php/perl webpages using the database. I current use sequences in postgres and

[GENERAL] Differences between postgres and mysql

2004-02-18 Thread Mark Cubitt
the reason I ask is I have always used postgres at home and work, but my new web host only has mysql :( I want to know what sort of differences I will have in regards to programming php/perl webpages using the database. I current use sequences in postgres and understand this will be different in