Ash Elixir•3y ago

How to create a partial index with Ash?

I was wondering, can I create a partial index using identities or some other way with Ash or should I just write a migration manually directly? For example, how can I do this partial index?

create index(:users, [:id], where: "not \"invalid_token?\"", name: :users_valid_tokens)

create index(:users, [:id], where: "not \"invalid_token?\"", name: :users_valid_tokens)

7 Replies

Ash HQ Bot•3y ago

Found 3 results in ash_postgres: * custom_indexes: https://ash-hq.org/docs/dsl/ash_postgres/1.3.9/ashpostgres/postgres/custom_indexes * custom_indexes: https://ash-hq.org/docs/module/ash_postgres/1.3.9/ashpostgres-datalayer-info#function-custom_indexes-1 * custom_indexes: https://ash-hq.org/docs/module/ash_postgres/1.3.9/ashpostgres#function-custom_indexes-1

ZachDaniel•3y ago

You can do it with custom_indexes 😄 that top result

BlibsOP•3y ago

Sorry, I was trying to search the docs with the partial word 😅

ZachDaniel•3y ago

would go inside the postgres section, like:

postgres do
  custom_indexes do
    custom_index ...
  end
end

postgres do
  custom_indexes do
    custom_index ...
  end
end

no worries 😄 I think its on us to include common search terms in the docs for things so that people can find it better when searching 😄

BlibsOP•3y ago

And I guess if I want to make the changeset aware of that index I need to use check_constrains right?

ZachDaniel•3y ago

nope, it will be aware of that index 🙂

BlibsOP•3y ago

Nice!

Gaming

Programming

How to create a partial index with Ash?

Did you find this page helpful?