Re: Strategy for preparing a query containg dynamic case / when

2022-08-11 Thread Theofilos Theofovos
Hi subin, can you clarify please? On Thu, Aug 11, 2022 at 3:42 PM subin wrote: > Please let me know if that is okay. > > On Thu, Aug 11, 2022 at 11:11 AM Theofilos Theofovos > wrote: > >> Hello, >> >> just for the sake of the example lets have this

Strategy for preparing a query containg dynamic case / when

2022-08-11 Thread Theofilos Theofovos
Hello, just for the sake of the example lets have this kind of table CREATE TABLE experimentals ( indy integer not null primary KEY, XXX1 integer NOT NULL, XXX2 integer NOT NULL, json_data jsonb ); It emulates a case where an item has integer labels XXX1, and XXX2 and characteristics de