Sorting transform function in PostgreSQL

Anonymous October 5, 2008 Reply

No need to put it in the results:

SELECT id, identifier,
FROM questions
WHERE section=123
ORDER BY SUBSTRING(identifier FROM '[0-9]{1,2}')::INT, identifier