Михаил

@MinhLA1410 , will https://github.com/pgspider/sqlite_fdw/pull/97/commits/1db7f67501347ccecec093eb881ded5ccc0b4581 enough?

> (mean -infinity < - 1 < 0 < 1 < +infinity), after your implementation sqlite_fdw can sorted values correctly. > Because I tested with **sqlite_fdw master branch**, the results...

> Your PR makes the sorting correct with arithmetic order on Postgres, Is it correct? Yes. Because in PostgreSQL there is 2 possible methods of ∞ value input: text constant...

@MinhLA1410 , just for info around of this PR and about different ∞ processing between PostgreSQL and SQLite . From https://www.sqlite.org/releaselog/3_45_3.html > Changes in this specific patch release, version 3.45.3...

All review rounds are completed, all comments are checked, @MinhLA1410. Does this means the next round will de done by @t-kataym ?

Thanks, to pgspider team, @t-kataym ! Now I can prepare PR about `NaN` after some decision around of https://github.com/pgspider/sqlite_fdw/issues/36#issuecomment-2117350187 or I need help with testing environment for https://github.com/pgspider/sqlite_fdw/pull/96 , because...

@MinhLA1410, could you please ask @t-kataym about [PR](https://github.com/pgspider/sqlite_fdw/pull/100) around of [`NaN`](https://github.com/pgspider/sqlite_fdw/pull/100) support? I think this is short and easy PR.

@Soni-Harriz, any SQL?

In PostgreSQL there is correct SQL ```sql SELECT FLOAT8 '+infinity' "+∞", FLOAT8 '-infinity' "-∞", FLOAT8 'NaN' "NaN"; ``` OK, there is support of all special values. Let's test SQlite. ```sql...

> SQLite does not have a concept of 'Infinity' and 'NaN' as a number. Let's test `select typeof(n),* from "Float";` from previous example. |typeof(n)|n| |---------|-| |text|NaN| |real|2.0| |real|0.0| |real|5.0| |text|-infinity|...