On Fri, 27 May 2022 at 18:19, Andrus wrote:
> Hi!
>
>
> Product type table contains product types. Some ids may missing :
>
> create table artliik (liiginrlki char(3) primary key);
> insert into artliik values('1');
> insert into artliik values('3');
> insert into artliik values('
On Fri, May 27, 2022 at 9:19 AM Andrus wrote:
> Product type table contains product types. Some ids may missing :
>
>
> create table artliik (liiginrlki char(3) primary key);
>
As an aside, don't use the "character" data type:
https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_cha
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 rang
