Size: a a a
YS
? на -> с проверкой на налл будет использоваться индекс?YS
? не могу, потому что ограничение препейред стейтмента.KL
IZ
YS
ИТ
KL
{ "5421bba9-1af5-4bbf-b266-821318040caf": { .. } }KL
SELECT * FROM table_name WHERE column_name -> "5421bba9-1af5-4bbf-b266-821318040caf" IS NOT NULLAL
ИТ
ДМ
AL
XX
ДМ
YS
ДМ
CREATE OR REPLACE VIEW public.contacts_count
AS SELECT contacts.user_id,
count(contacts.user_id) AS count
FROM contacts
WHERE contacts.contact_origin::text = 'Authentic'::text
GROUP BY contacts.user_id;
YS
CREATE OR REPLACE VIEW public.contacts_count
AS SELECT contacts.user_id,
count(contacts.user_id) AS count
FROM contacts
WHERE contacts.contact_origin::text = 'Authentic'::text
GROUP BY contacts.user_id;
ДМ
YS
ДМ