Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

CREATE TABLE public.test_tablica1 (
id SERIAL,
podaci jsonb,
datum_upisa TIME WITHOUT TIME ZONE);

CREATE TABLE


INSERT INTO public.test_tablica1 VALUES ('1', '[

{
	"id": "1",
	"firstName": "Tom",
	"lastName": "Cruise"
},
{
	"id": "2",
	"firstName": "Maria",
	"lastName": "Sharapova"
},
{
	"id": "3",
	"firstName": "James",
	"lastName": "Bond"
}
]'

, now());

INSERT 0 1


SELECT * FROM public.test_tablica1


id
podaci
datum_upisa


1
[{"id": "1", "lastName": "Cruise", "firstName": "Tom"}, {"id": "2", "lastName": "Sharapova", "firstName": "Maria"}, {"id": "3", "lastName": "Bond", "firstName": "James"}]
19:22:14.62235



SELECT 1


UPDATE public.test_tablica1
SET podaci = jsonb_set(podaci, '{"lastName"}', '"Kirin"'::jsonb, TRUE)
WHERE id = 2 AND podaci::json->>'firstName'='Maria';

UPDATE 0


SELECT * FROM public.test_tablica1


id
podaci
datum_upisa


1
[{"id": "1", "lastName": "Cruise", "firstName": "Tom"}, {"id": "2", "lastName": "Sharapova", "firstName": "Maria"}, {"id": "3", "lastName": "Bond", "firstName": "James"}]
19:22:14.62235



SELECT 1