I am trying to sort a column title from the table door with the following PostgreSQL query: SELECT title FROM door ORDER BY CASE WHEN title ~ '^d+' THEN CAST(regexp_replace(title, '[^0-9]', '', 'g') AS INTEGER) ELSE NULL END ASC, CASE…
I'm looking for an efficient way to sort a list of Alphanumeric labels but ignoring to sort the hexadecimal values like below. arr = [ "a_19", "a_2", "b_645500", "b_6d4500" ] I've read the solution here Using { numeric: true }…
I have the following table of inventory stock symbols and want to fetch the highest alphanumeric value which is AR-JS-20. When I say "highest" I mean that the letter order is sorted first and then numbers are factored in, so…
In Postgres I need to sort text with natural order, but with one exception - if the string has only number, it should be placed at top. So I need such order: ["98", "125", "134", "148", "265", "634", "1233", "5231",…
I have a variable that stores current time with $current_time and another variable with an array of time stored in $time_slot I am looking for a way around to unset from array variable $time_slot all array of time that is…