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

2022-08-11 Thread David G. Johnston
On Thu, Aug 11, 2022 at 1:19 PM Theofilos Theofovos wrote: > Hi subin, > > can you clarify please? > > I got a random nonsensical reply from this sender earlier today too...spam/hack/whatever, probably best to just ignore. David J.

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 kind of table >> >> CREATE TABLE experimenta

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