Hi,
I am using ORDER BY to sort rows based on a column containing strange strings like ("?@@??$&##ADSDG"
.
Sample of the column:
ev_0516=# select * from temp order by sortare;
sortare
---------
???&&
?&&#
1?&&#
1?&&#
1?A
1?&#A
1M
1?M
2A
2M
?A
?&&#A
A^
AZ
?BA
BA?
BB
?MA
?ZA
(19 rows)
I need to obtain a real sort based on charcodes that will at least group toghether strings starting with ? or @.
Am I stupid or what ???
I am using ORDER BY to sort rows based on a column containing strange strings like ("?@@??$&##ADSDG"
.Sample of the column:
ev_0516=# select * from temp order by sortare;
sortare
---------
???&&
?&&#
1?&&#
1?&&#
1?A
1?&#A
1M
1?M
2A
2M
?A
?&&#A
A^
AZ
?BA
BA?
BB
?MA
?ZA
(19 rows)
I need to obtain a real sort based on charcodes that will at least group toghether strings starting with ? or @.
Am I stupid or what ???