Re: Determine if range list contains specified integer

[Adrian Klaver]

On 5/27/22 03:51, Andrus wrote:

Hi!

How to all properties for given type.
Query

     select id
     from artliik

    join strings on ','||trim(strings.kirjeldLku)||',' like '%,'||trim(artliik.liiginrlki)||',%'

returns date for single integer list only.
How to change join so that type ranges in list like 6-9 are also returned?
Eq. f list contains 6-9, Type 6,7,8 and 9 shoud included in report.

Start over with a more rational data model.

Andrus.

--
Adrian Klaver
adrian.kla...@aklaver.com