Re: [sqlite] Unaligned access in SQLite on Itanium

2006-03-26 Thread Alexei Alexandrov
> > Well, it's supported by most compilers today, but I try to avoid > anonymous unions in C code as well. They are fairly standard for C++, > but not for C. But the approach seems fine to me - the alignment will > be forced in this case. > Just to make it clear: can I expect this fix in the next

Re: [sqlite] How to get the schema

2006-03-26 Thread Philipp Knüsel
> Is there another way to get the column schema besides parsing the original > CREATE TABLE command? > > thx > -Brett G. > > > This message was sent using IMP, the Internet Messaging Program. Hello Brett You can access the

Re: [sqlite] How to get the schema

2006-03-26 Thread Boris Popov
Brett Goodman wrote: Is there another way to get the column schema besides parsing the original CREATE TABLE command? Sure, sqlite3_table_column_metadata, see http://sqlite.org/capi3ref.html#sqlite3_table_column_metadata This routine is used to obtain meta information about a specific

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
Hello everybody, On 26/03/2006, at 10:08, John Stanton wrote: LIKE and GLOB do a row scan, and give you none of the advantages of an RDBMS. Why not use a flat file and grep and get simplicity and greater speed? I'm very well aware that LIKE and GLOB perform a row scan. I do appreciate

[sqlite] How to get the schema

2006-03-26 Thread Brett Goodman
Is there another way to get the column schema besides parsing the original CREATE TABLE command? thx -Brett G. This message was sent using IMP, the Internet Messaging Program.

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Boris Popov
John Stanton wrote: Tito Ciuro wrote: On 26/03/2006, at 10:51, MGC wrote: Your design is fundamentaly wrong. I don't know what your intended use is for this data, but I am logging identical fstat file info along with an MD5 sums. Well... if you don't know what is the intended use for

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread John Stanton
Tito Ciuro wrote: On 26/03/2006, at 10:51, MGC wrote: Your design is fundamentaly wrong. I don't know what your intended use is for this data, but I am logging identical fstat file info along with an MD5 sums. Well... if you don't know what is the intended use for the data, how can you

Re: [sqlite] Re: How to invert positional argument in ORDER BY

2006-03-26 Thread Nemanja Corlija
On 3/26/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Nemanja Corlija <[EMAIL PROTECTED]> wrote: > > I have a following query: > > SELECT date FROM chng ORDER BY -date; > > > > Is there a way to use positional argument (hopefully that's the right > > term) instead of column name here? > >

[sqlite] Re: How to invert positional argument in ORDER BY

2006-03-26 Thread Igor Tandetnik
Nemanja Corlija <[EMAIL PROTECTED]> wrote: I have a following query: SELECT date FROM chng ORDER BY -date; Is there a way to use positional argument (hopefully that's the right term) instead of column name here? Something like this: SELECT date FROM chng ORDER BY -1; select date, -date from

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
On 26/03/2006, at 10:51, MGC wrote: Your design is fundamentaly wrong. I don't know what your intended use is for this data, but I am logging identical fstat file info along with an MD5 sums. Well... if you don't know what is the intended use for the data, how can you say that my design

[sqlite] How to invert positional argument in ORDER BY

2006-03-26 Thread Nemanja Corlija
I have a following query: SELECT date FROM chng ORDER BY -date; Is there a way to use positional argument (hopefully that's the right term) instead of column name here? Something like this: SELECT date FROM chng ORDER BY -1; This fails with a message "ORDER BY column number -1 out of range -

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread MGC
There may be an issue, but. Your design is fundamentaly wrong. I don't know what your intended use is for this data, but I am logging identical fstat file info along with an MD5 sums. Each informational element needs to be stored in an individual column. Stuffing all those fields into a

[sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
Hello, I've populated a datafile with 40.176 records which contain file attributes and file paths. I have two columns, CMKey and CMValues. The column CMKey contains the path to the file and the column CMValues contains the attribute values. For example: CMKey: Application