Edoardo Serra wrote:
> SELECT * FROM dummy ORDER BY string ASC;
> string
>
> 100%
> 10.1
> (2 rows)
>
> I would expect the order of the results to be '100%', '10.1'.
> Moreover, if I use the following dataset, I get the correct sorting
>
> SELECT string, ascii(substr(string, 3, 1))
Hi guys,
I found a weird behaviour in sorting character varying columns, I think
it could really be a bug.
Table definition:
CREATE TABLE dummy (string character varying(255));
Test dataset:
INSERT INTO dummy VALUES ('10.');
INSERT INTO dummy VALUES ('100');
If I query the table sorting
