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
>> You will be told MySQL doesn't set the standard :-)
> the same query in postgresql have have same result of Mysql.
And nor does Postgresql.
> Mysql and postgresql have the same behavior and sqlite is different.
>
> what do you think about this?
> where I am mistaking?
You are making a mistake
[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
Andrea Federico Grisotto wrote:
*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.
just food for thought: when you're asking an ambiguous question (like in
the case of comparing apples with
>
>> 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 be told MySQL doesn't
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);
7 matches
Mail list logo
