Re: [sqlite] Adding SQL commands

2004-04-15 Thread Joel Rosdahl
Bertrand Mansion <[EMAIL PROTECTED]> writes: > <[EMAIL PROTECTED]> wrote : > >> I have a similar problem with character encoding in the current >> SQLite versions, by the way. I store UTF-8 encoded data from a >> Python program using PySQLite using a prepackaged SQLite, but since >> the

Re: [sqlite] Adding SQL commands

2004-04-15 Thread Bertrand Mansion
<[EMAIL PROTECTED]> wrote : > I have a similar problem with character encoding in the current SQLite > versions, by the way. I store UTF-8 encoded data from a Python program > using PySQLite using a prepackaged SQLite, but since the prepackaged > libsqlite is built without SQLITE_UTF8, I can't

Re: [sqlite] Adding SQL commands

2004-04-14 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: Great...can you tell me if there will be any increased technical specs??? Ver 3.0 will have a 64-bit ROWID, what about: - page size 512 to 64K selectable at compile-time. Default: 1K - max table rows 2^64 - max database size 2^32 pages. The current

RE: [sqlite] Adding SQL commands

2004-04-14 Thread basil . thomas
. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Adding SQL commands [EMAIL PROTECTED] wrote: > [I]f version 3.0 is a foundation move to implement enhanced language > functionality later,... That is a c

Re: [sqlite] Adding SQL commands

2004-04-14 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: > [I]f version 3.0 is a foundation move to implement enhanced language > functionality later,... That is a correct assessment. SQLite version 3.0.0 is an enhancement to the foundation. SQL Langauge enhancements can be made later and in a backwards-compatible way. The

RE: [sqlite] Adding SQL commands

2004-04-14 Thread basil . thomas
MAIL PROTECTED] Sent: Tuesday, April 13, 2004 7:20 PM To: Thomas, Basil; [EMAIL PROTECTED] Subject: Re: [sqlite] Adding SQL commands Hi Basil, The first use of IF is same syntax as the case statement so I don't think it is required and as IF isn't SQL92 I doubt it will be included so your command i

Re: [sqlite] Adding SQL commands

2004-04-13 Thread Greg Obleshchuk
: Wednesday, April 14, 2004 8:03 AM Subject: [sqlite] Adding SQL commands I would like to add some commands to SQLite to make my SQL(ite) programming life easier!!! The commands are: IF - e.g IF ((select count(*) from foo) = 100) select "good"; ELSE s

[sqlite] Adding SQL commands

2004-04-13 Thread basil . thomas
I would like to add some commands to SQLite to make my SQL(ite) programming life easier!!! The commands are: IF - e.g IF ((select count(*) from foo) = 100) select "good"; ELSE select "bad"; END