Useful Tips

Postgres sort numeric on text varchar column

Natural sort on Postgres - order by numeric value on text and varchar column