Subject Re: [firebird-support] SELECT with CTE and LIST: Duplicates with DISTINCT and incorrect ordering in the main select
Author Michal Kurczabinski
Post date 2017-05-30T08:51:48Z
First thought:
you should cast as varchar list expr as
cast (list(distinct 'I shouldn''t duplicate') as varchar(100)), cast(list(distinct substring('Hello' from 1 for 5)) as varchar(100))
in each occurence of list



--
regards,
Michał Kurczabiński