[EMAIL PROTECTED] wrote:
fromId VARCHAR(6),
toId VARCHAR(6),
excuse me, this was a stupid question:
*fromId* and *toId* are VARCHAR, if I use *int* the behavior is correct,
excuse me again, but remain the difference behavior between sqlite and
Mysql.
You will be told MySQL doesn't set the standard :-)
the same query in postgresql have have same result of Mysql.
postgres=# SELECT * from np WHERE (42>=fromId) AND (42<=toId);
fromid | toid | serviceid
--------+------+-----------
40 | 43 | 3
(1 row)
Mysql and postgresql have the same behavior and sqlite is different.
what do you think about this?
where I am mistaking?
bye Andrea.
