Re: virtual fields on VIEW?

On Mon, 2004-06-21 at 13:34, Richard Huxton wrote:
> raptor wrote:
> >
> > ]- re: to myself... In fact I was using postgres in the past afaik
> > 6.x versions or so (no outer joins, rule system was still not fully
> > working ... it was good on paper was good but, ... now glad it has
> > advanced so much :")).. then i got using Inter Base(FireBird).
> > (really cool db :") ) From what I see 7.x series has made huge step
> > forward.. probably now surpacing firebird on features side.. (they
> > had hard time adapting Interbase code) (no flame pls!)
>
> Firebird is the only viable open-source alternative to PG that I can
> think of (which has been a viable project for any length of time).
>
> > AFAIK firebird(interbase) and postgres are the only DB with
> > multiversioning engines, is that true ?
>
> I think Oracle has its version.

According to the author of them, innodb tables under MySQL use MVCC as
well. Now if someone could just fix the parser in MySQL to not be
broken...