From: Emil Totev <emil.totev@gm...> - 2007-07-23 10:24:18
>> create view X as
>> select rdb$relation_name from rdb$relations where rdb$system_flag = 0
>> union all
>> select rdb$relation_name from rdb$relations where rdb$system_flag = 1
>> Any comments?
>If both union parts would have different column names, which one should
>be preferred to become a view column name?
Quote from Chapter 22 of The Firebird Book:
"The column identifiers of the output set are those specified in the
first SELECT specification.
If you would like to use alternative column names, column aliasing can
be used in the
output list of the first SELECT specification"
Seems pretty straight-forward to use the same logic for the view
column names as well.