leaflet.pub / leaflet
a tool for shared writing and social publishing
fork atom
leaflet / supabase / migrations / 20250827115826_updated_reference_index.sql
at main 2 lines 305 B view raw
awarm.space add new facts_reference index
bae52e8e
1CREATE INDEX CONCURRENTLY facts_reference_idx2 ON public.facts USING btree (((data ->> 'value'::text))) WHERE (((data ->> 'type'::text) = 'reference'::text) OR ((data ->> 'type'::text) = 'ordered-reference'::text) OR ((data ->> 'type'::text) = 'spatial-reference'::text)); 2drop index facts_reference_idx;