Re: [firebird-support] SELECT with CTE and LIST: Duplicates with DISTINCT and incorrect ordering in the main select

[Michal Kurczabinski michk...@gmail.com [firebird-support]]

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