Re: Firebird and PostgreSQL at the DB Corral.

paul@tmsl.demon.co.uk says...

> > X (I assume that what is meant here is MVCC?)


> One thing I couldn't find when looking at the FB on-line docs a week or
> two ago was anything like support for transaction isolation level
> serializable. Whilst the PG docs states taht its implementation of t.i.l.s
> is not quite to SQL spec, it is still very good as you don't need to lock
> rows with select ... for update. How does FB do in this respect?


To the best of my knowledge, FB does support serialisable transaction
level - I'm 95% sure that it does - will look into this and report back!


> > > Functional and Partial indexes
> > O
> No partial indexes? Get them to put it on their TODO list ;)


What, exactly, is a partial index? A functional index is an index on
something like ((ColumnX*2)/14)? I think the functional one (is that
also an expression index?) is on the way.


> BTW, has FB got an equivalent of PG sequences?


Yes - "Generators" - easy and simple.


Paul...



--

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.