postgres=# SELECT * from np WHERE (42>=fromId) AND (42<=toId);
fromid | toid | serviceid
+--+---
40 | 43 | 3
(1 row)
please forget it,this an error.
-
To unsubscribe, send email to
[EMAIL PROTECTED] wrote:
fromIdVARCHAR(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 b
fromIdVARCHAR(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.
bye Andrea.
I have a table like this:
CREATE TABLE np (
fromIdVARCHAR(6),
toId VARCHAR(6),
serviceId INTEGER,
PRIMARY KEY (fromId, toId)
);
and I insert these values:
INSERT INTO np VALUES ( 0, 5, 2);
INSERT INTO np VALUES ( 40, 43, 3);
INSERT INTO np VALUES (440,499, 3);
INS
4 matches
Mail list logo
