Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Adam Lang
;[EMAIL PROTECTED]> Sent: Wednesday, January 24, 2001 11:47 AM Subject: Re: [GENERAL] MySQL has transactions > > > David Wall schrieb: > > > > Now that MySQL has transaction support through Berkeley DB lib, and it's > > always had way more data types, what are th

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread David Wall
> > Something I'm curious about: does MySQL support user-defined datatypes? > > No, it does not. > > > If so, how hard is it to make a new datatype? I think datatype > > extensibility is one of the cooler features of Postgres ... Making new datatypes sounds good, but in practice how easy is it t

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Brett W. McCoy
On Wed, 24 Jan 2001, Peter Eisentraut wrote: > David Wall writes: > > > Now that MySQL has transaction support through Berkeley DB lib, and it's > > always had way more data types, > > I count 25 documented and distinct data types for MySQL, and 30 for > PostgreSQL. Not to mention that Postgres

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Brett W. McCoy
On Wed, 24 Jan 2001, Tom Lane wrote: > Something I'm curious about: does MySQL support user-defined datatypes? No, it does not. > If so, how hard is it to make a new datatype? I think datatype > extensibility is one of the cooler features of Postgres ... Check this out: http://www.mysql.com/d

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Marten Feldtmann
David Wall schrieb: > > Now that MySQL has transaction support through Berkeley DB lib, and it's > always had way more data types, what are the main advantages postgresql has > over it? I don't think mysql has subselects and such, but they did add a > master-slave replication feature as well a

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Tom Lane
>> I though that postgresql had more data type > no, MySQL has 'type of the week' contests to see how many non-compliant > types they can think of, and add them ... Something I'm curious about: does MySQL support user-defined datatypes? If so, how hard is it to make a new datatype? I think data

Re: [GENERAL] MySQL has transactions

2001-01-24 Thread Peter Eisentraut
David Wall writes: > Now that MySQL has transaction support through Berkeley DB lib, and it's > always had way more data types, I count 25 documented and distinct data types for MySQL, and 30 for PostgreSQL. http://www.postgresql.org/devel-corner/docs/postgres/datatype.htm http://www.mysql.com/

RE: [GENERAL] MySQL has transactions

2001-01-24 Thread The Hermit Hacker
On Wed, 24 Jan 2001, Willis, Ian (Ento, Canberra) wrote: > speed with tranactions on > row level locking > I though that postgresql had more data type no, MySQL has 'type of the week' contests to see how many non-compliant types they can think of, and add them ...