Subject | distinct on list() function |
---|---|
Author | Michal Kurczabinski |
Post date | 2019-11-12T12:37:44Z |
Is this old bug from FB 2.5.x or some kind of feature ?
This still exists in FB 3.x
with cte as
(select 1 cnt from rdb$database
union all
select 2 from rdb$database
)
select list(cnt) from cte
union
select list(cnt) from cte
--
Regards,
Michał Kurczabiński
This still exists in FB 3.x
with cte as
(select 1 cnt from rdb$database
union all
select 2 from rdb$database
)
select list(cnt) from cte
union
select list(cnt) from cte
--
Regards,
Michał Kurczabiński