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.