Firebird 1.5
SQL> CREATE TABLE test1(a VARCHAR(100));
SQL> INSERT INTO test1 VALUES('501');
SQL> INSERT INTO test1 VALUES(' 502 ');
SQL> SELECT * FROM test1 WHERE a=501;
A
===
501
SQL> SELECT * FROM test1 WHERE a=502;
Ditto that.
[EMAIL PROTECTED]
com
Not only comparison, but all expressions - arithmetic etc.
[EMAIL PROTECTED]
com
Yep. basically our "type less" string fields should have user definable
operator overload functions. Sounds like a big change that I doubt DRH would
implement anytime soon but it would definitely solve some of these
integer/numeric/string/datetime/etc.. conversion/comparisons. We would also
have
I have a program (spey, http://spey.sf.net, an email spam filter) that
maintains a database of recently seen email addresses using Sqlite. Everyone
works very nicely. Periodically a process runs that purges the database of
stale addresses. This is just a little script that runs the sqlite shell
Hello Dr. Hipp,
Hello SQLite users,
in MS SQL Server, the following line
SELECT '500' = 500;
returns a column having the alias '500' and the value 500 :-o
However, wanting to test how the engine compares strings and numbers:
SELECT 'match' WHERE '500' = 500;
returns 'match'; also, the
While trying to attach a readonly database to another one, I get the message
« root page number less than 2 , It reproduces itself almost each time.
I precise the database which has to be attached is a readonly one.
Do you have some idea ?
Thanks a lot, and excuse me for my english.
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
I think it should return 0.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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,
Hello,
In mysql:
mysql> SELECT * FROM test1 WHERE a=501;
+--+
| a|
+--+
| 501 |
+--+
1 row in set (0.02 sec)
mysql> SELECT * FROM test1 WHERE a=502;
+---+
| a |
+---+
| 502 |
+---+
1 row in set (0.00 sec)
mysql> SELECT * FROM test1 WHERE a<'502';
+---+
| a
Sybase ASE 12.5.1:
CREATE TABLE test1(a VARCHAR(100))
INSERT INTO test1 VALUES('501')
INSERT INTO test1 VALUES(' 502 ')
SELECT * FROM test1 WHERE a=501
SELECT * FROM test1 WHERE a=502
SELECT * FROM test1 WHERE a<'502'
Result: "Implicit conversion from datatype 'VARCHAR'
I agree that compatibility is what counts...
Felipe Lopes
Em 12 May 2004, Shawn Anderson escreveu:
>I agree, I would like to see compatibility with results from other SQL
>engines...
>
>Shawn
>
>-Original Message-
>From: Keith Herold [mailto:[EMAIL PROTECTED]
>Sent: Wednesday,
Funny, I thought SQL was a more down to earth version of E. F. Codd's
mathematical model 'Relational Algebra', with some concepts taken from
Relational Calculus.
To say types and strong typing weren't part of the original SQL concept
isn't right. Typing gives data semantics.
Vijay
I guess you read different books than I. The intent was to have the
language engine do the required type conversions freeing the user from
knowledge of such "technical" things. Like all languages it evolved, and
has not remained "simple."
Fred
> -Original Message-
> From: [EMAIL
> Who can tell me what other SQL database engines do with
> the following?
>
>CREATE TABLE test1(a VARCHAR(100));
>INSERT INTO test1 VALUES('501');
>INSERT INTO test1 VALUES(' 502 ');
>SELECT * FROM test1 WHERE a=501;
>SELECT * FROM test1 WHERE a=502;
>SELECT * FROM test1
On Thu, 13 May 2004, David Given wrote:
>
>I'm running sqlite 0.8.6 on a Debian stable build. I have no idea whether it's
>been compiled with the thread-safety flag or not, there are no release notes.
Not sure whether that's a typo or not, but testing has 2.8.13 available,
so you may want to
Hi!
I can use SQLLite with Visual Basic without using other external DLL
Any sample of using sqlite.dll API?
Thanks
Carlos Garcés
.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
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
Similar for Sybase ASE 12.5 (wasn't it MSSQL
ancestor ?):
SELECT '500' = 500
500
===
500
SELECT 500 = '500'
Incorrect syntax near '='
I think "SELECT '500' = 500" is not a comparison here,
just selection of constant 500 with '500' as column
name, just like "select 500 as '500'".
Regards,
There is a VBWrapper.zip in the old SQLite yahoo
group's file section. The archive contains wrapper
over the SQLite API so that it can be used from VB.
The API declarations for VB are also in the archieve.
Get it from here:
Hi Carlos,
Sorry mate I didn't point out the wrappers on Sqlite.Org
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Greg
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: Friday, 14 May 2004 11:13 AM
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re:
I have the following table/data
ClientIPClientDomain
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
63.149.28.33mail.serverlocation.com
211.141.67.7xmailserver.org
211.141.67.7xmailserver.org
23 matches
Mail list logo