Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-03-01 Thread RSmith
On 2014/03/01 10:32, Darren Duncan wrote: If you're going by semantics though, the meanings are quite different. A real number represents a point on a line and can be either a rational or irrational number. (And a complex number is a point on a plane.) An important bit is that a real is a

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-03-01 Thread Darren Duncan
On 3/1/2014, 12:16 AM, RSmith wrote: On 2014/02/28 23:36, L. Wood wrote: SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants.

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-03-01 Thread RSmith
On 2014/02/28 23:36, L. Wood wrote: SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. Quoting Shakespeare's Juliet: "What's in

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-02-28 Thread Richard Hipp
On Fri, Feb 28, 2014 at 4:36 PM, L. Wood wrote: > SQLite has the REAL data type: > > https://www.sqlite.org/datatype3.html > > Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other > data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. > >

[sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

2014-02-28 Thread L. Wood
SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. Is this just a historical quirk that stuck, or something else?