Skip to content

Instantly share code, notes, and snippets.

@ValentinMouret

ValentinMouret/index_a_generated_field.sql

Created June 6, 2022 16:38
Show Gist options
  • Save ValentinMouret/3e262bae94924c2b6f0a6fcb93458279 to your computer and use it in GitHub Desktop.
Save ValentinMouret/3e262bae94924c2b6f0a6fcb93458279 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
index_a_generated_field.sql
alter table firestore.collection
add column author text generated always as (document->>'author') stored;
create index firestore_collection_author_idx
on firestore.collection (author);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment