[sqlite] Re: EXISTS and NULLs

2008-01-02 Thread Aristotle Pagaltzis
at this construct must work in MySQL, Postgres, Oracle, DB2, SQL Server and Sybase. It’s a safe bet that SQLite works as expected. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: Trying to use SQLite3 with PHP5....

2008-01-04 Thread Aristotle Pagaltzis
nciple any of the current crop of dynamic languages should suffice, though the major ones do not make it nearly as easy as Tcl to write bindings to C libraries. (I hear that Ruby is not half bad in this regard, though.) Regards, -- Aristotle Pagalt

[sqlite] Re: "always-trim" - feature suggestion

2008-01-09 Thread Aristotle Pagaltzis
ryone’s problems, not just the butt-pimple of the week. A language designer must be even better at doing this, because many, many people will be stuck with the language for years. SQLite’s design doesn’t quite constitute a full-blown language, but it’s more demanding than a plain libra

[sqlite] Re: "always-trim" - feature suggestion

2008-01-09 Thread Aristotle Pagaltzis
* Zbigniew Baniewski <[EMAIL PROTECTED]> [2008-01-09 12:15]: > Keep your flamewar just to yourself, will you? I’m sorry if that’s all you saw in my mail. Regards, -- Aristotle Pagaltzis // <http://pla

[sqlite] Re: "Can't we all just get along?" [Was: Re: "always-trim" - feature suggestion]]

2008-01-09 Thread Aristotle Pagaltzis
hread yet). Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: "always-trim" - feature suggestion

2008-01-09 Thread Aristotle Pagaltzis
nted features are by definition bloat. Linus Torvalds once said that his most important job as the maintainer of the kernel is to say no to most suggested additions. I’m sure Dr. Hipp could give a list of things he would remove from SQLite if backward compatibility was not a concer

[sqlite] Re: Strange error "Incomplete SQL"

2008-01-21 Thread Aristotle Pagaltzis
error... why? > the problem persist using /*COMMENT*/ style $ echo -e '\n;' >> error $ sqlite < x $ The sqlite shell doesn’t parse SQL, it just looks for a semicolon as a statement terminator, so it sees your comment after it sees the SELECT statement, but doesn’t find

[sqlite] Re: Strange error "Incomplete SQL"

2008-01-21 Thread Aristotle Pagaltzis
* Aristotle Pagaltzis <[EMAIL PROTECTED]> [2008-01-21 22:29]: > $ echo -e '\n;' >> error > $ sqlite < x > $ Err, the 2nd line is of course > $ sqlite < error Regards, -- Aristotle Pagalt

Re: [sqlite] Mailing List Changes

2008-02-04 Thread Aristotle Pagaltzis
ated support for mailing lists, nearly half a century after the birth of SMTP.) Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] IE6 (was: Updatable views)

2008-02-17 Thread Aristotle Pagaltzis
of breakage between two versions of any of their browsers would be small, whereas MSFT ignored the browser for some six years. *That* is how they buggered up. Anyway. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ___ sqlite-user

Re: [sqlite] Most widely deployed?

2008-02-21 Thread Aristotle Pagaltzis
p, much less the commercial ones. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Most widely deployed?

2008-02-21 Thread Aristotle Pagaltzis
* Shawn Wilsher <[EMAIL PROTECTED]> [2008-02-21 20:00]: > > Every copy of Firefox 3 contains a copy of SQLite. > And Firefox 2 ;) Really? What is it used for? Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ___ sqli

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-21 Thread Aristotle Pagaltzis
`Z` a shortcut for `+00`; no provision is made for other symbolic names as those only cause trouble. So you should have no trouble refusing requests to support those. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/> ___ sqlite-users mailing