KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am new to postrges and want to sort varchar type columns. want to explain the problem with with below example: table name: testsorting order name 1 b 2 B 3 a 4 a1 5 a11 6 a2 7 a20 8 A 9 a19 case sensitive sorting (which is default in postgres) gives: select name from testsorting order by name; A B a a1 a11 a19 a2 a20 b case in-sensitive sorting gives: select name from testsorting order by UPPER(name); A a a1 a11 a19 a2 a20 B b how can i make alphanumeric case in-sensitive sorting in postgres to get below order : a A a1 a2 a11 a19 a20 b B I wont mind the order for capital or small letters, but the order should be "aAbB" or "AaBb" and should not be "ABab" Please suggest if you have any solution to this in postgres.
Tags (comma-separated)
Save Edits
Cancel