> That's at least not true for Fb 1.0.2, which I am still using.
>
> I simply did:
>
> select * from rdb$fields f
> left join rdb$database d on d.rdb$relation_id = f.rdb$segment_length
>
> and it returned all records in rdb$fields even though many had NULL in
> segment_length.
>
> Are you saying that this has changed in Firebird 1.5 and that the
> above query
> would return only those records that had did not have a NULL value in
> rdb$fields.rdb$segment_length ???
>
> Set

v1.5 on my box returns nulls in segment_length
Alan