--- In firebird-support@yahoogroups.com, "R" wrote:
> Hi,
>
> I'm thinking of migrating to Firebird, and I was wondering if the
> following features were supported in it -
>
> Natural Join
I assume this is the same as a FULL OUTER JOIN. Firebird supports both
inner and outer joins.

> UNIQUE predicate
Unique constraints are possible, so is SELECT DISTINCT (I'm not
completely certain which of these you mean)

> Cascade delete
> Cascade Update
As part of foreign keys, yes.

> Bulk insert
> Bulk update
> Bulk fetch
Hmm, here I don't know. Of course it is possible to do
INSERT INTO <table>
SELECT FROM <othertable>
and similar for update. It is also possible to use external files when
defining tables and use these as a way to import files. Hopefully
someone else will jump in and give you a better answer when it comes
to these 'bulky things', I don't quite get what you are asking.

Set