16 replies

(Postgrex.Error) ERROR 42P18 (indeterminate_datatype) could not determine data type of parameter $1

Gotting the above error while try this code for a regex search.

Ash.Query.filter(fragment("task_id ~* '?\\d+'", ^prefix))

Ash.Query.filter(fragment("task_id ~* '?\\d+'", ^prefix))

Ash.Query.filter(fragment("task_id ~* '?\\d+'", ^prefix))

Ash.Query.filter(fragment("task_id ~* '?\\d+'", ^prefix))

The Ecto doc suggests explicitly defining type with

type(^prefix, :string)

type(^prefix, :string)

type(^prefix, :string)

type(^prefix, :string) but I'm not sure how it's supposed to fit in as an Ash.Query. expression.