hassaan_ayyub
hassaan_ayyub
PostsComments
AEAsh Elixir
Created by hassaan_ayyub on 8/30/2023 in #support
How to sort on a postgres regex?
Update: 
calculate :serial_no_int, :integer, expr(fragment("cast(substring(serial_no from '\\d+$') as integer)"))

...

Ash.Query.sort(serial_no_int: {:asc, %{}})
calculate :serial_no_int, :integer, expr(fragment("cast(substring(serial_no from '\\d+$') as integer)"))

...

Ash.Query.sort(serial_no_int: {:asc, %{}})
works.
3 replies