cc
[EMAIL PROTECTED]
Subject
RE: [sqlite] SQLite version 3
design question:
[EMAIL PROTECTED]
Subject
RE: [sqlite] SQLite version 3
design question: '500'=500
]
Subject
RE: [sqlite] SQLite version 3
design question: '500'=500
age-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 8:51 AM
> To: Fred Williams
> Cc: [EMAIL PROTECTED]
> Subject: RE: [sqlite] SQLite version 3 design question: '500'=500?
>
>
>
>
>
>
>
> Funny, I thought SQL was
cc
Subject
RE: [sqlite] SQLite version 3
ED]
>Sent: Wednesday, May 12, 2004 8:38 PM
>To: [EMAIL PROTECTED]
>Subject: RE: [sqlite] SQLite version 3 design question: '500'=500?
>
>In MS SQL 2000, through the query analyzer
>
> SELECT '500' = 500
>
>returns 500 .
>
> SELECT 500 = '500'
>
>ret
I have another suggestion which may help with the comparison for
sorting issue, but you may find it a bit outrageous.
Essentially, I suggest making SQLite a little bit less typeless.
You already have multiple underlying data type representations as I
recall, such as numbers, character strings,
At 8:19 PM -0400 5/12/04, D. Richard Hipp wrote:
The development team is making progress on SQLite version 3.0.
But we've run across an interesting puzzle. What should be
returned by this:
SELECT '500'=500;
Is the result "0" or "1"? In other words, what happens when
you compare a number to
00'".
Regards,
Jarek
> -Original Message-
> From: Shawn Anderson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 13, 2004 2:50 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [sqlite] SQLite version 3 design question: '500'=500?
>
>
> I agree, I would like to s
Another interesting data point, note the difference between ' and ".
Welcome to psql 7.4, the PostgreSQL interactive terminal.
kevin=# select '500'=500;
?column?
--
t
(1 row)
kevin=# select "500"=500;
ERROR: column "500" does not exist
On May 12, 2004, at 5:19 PM, D. Richard Hipp
ki [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 8:15 PM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] SQLite version 3 design question: '500'=500?
On Wed, May 12, 2004 at 05:37:49PM -0700, Keith Herold wrote:
> In MS SQL 2000, through the query analyzer
>
>SELECT '500' = 5
Results from Firebird 1.5 (thanks for the syntax, Andrew)...
SQL> select '500' = 500;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 14
-=
SQL> select 500 = '500';
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
In MS SQL 2000, through the query analyzer
SELECT '500' = 500
returns 500 .
SELECT 500 = '500'
returns
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '='.
Beyond these, I have no preference on whether they are true or false; I am
less worried
Hello,
On 12 may 2004, at 20:19, D. Richard Hipp wrote:
SELECT '500'=500;
Is the result "0" or "1"? In other words, what happens when
you compare a number to a string that looks like that number.
Are they equal or not?
I vote for "0".
Regards,
-- Tito
14 matches
Mail list logo
