Monday, February 9, 2009

Firebird Multiset or Array???

Does anyone know how Firebird uses MULTISET or ARRAY datatypes? I can't find anything...

2 comments:

Unknown said...

Multisets are not supported.

There is basic array support. This is what the SQL Conformance page lists as supported features:

S091 Basic array support
S091-01 Arrays of built-in data types: Implementation is non-standard and limited to DSQL only

That Conformance page can be found here.

I know this still doesn't tell you exactly how arrays are handled, but thought this would offer you a starting point.

Unknown said...

In a somewhat related note, I meant to also mention that assertions are not supported in Firebird.