Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-27 Thread Pavel Ivanov
wrote: > >> To: SQLite Users Digest >> From: Rob Sciuk >> Subject: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ... >> >> >> I've just compiled the latest (3.6.19) with the > > I'm using a pre-compiled version shipped with Fedora. > >

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-27 Thread Keith Roberts
On Mon, 26 Oct 2009, Rob Sciuk wrote: > To: SQLite Users Digest > From: Rob Sciuk > Subject: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ... > > > I've just compiled the latest (3.6.19) with the I'm using a pre-compiled version shipped with Fedora. As a matte

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread BareFeet
Hi all, On Mon, Oct 26, 2009 at 05:28:50PM -0400, Rob Sciuk scratched on the wall: > > I've just compiled the latest (3.6.19) with the > > -DSQLITE_ENABLE_COLUMN_METADATA flag set. This intrigues me. The functions that this enables looks very useful. Please forgive my obvious ignorance here,

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread Rob Sciuk
On Mon, 26 Oct 2009, D. Richard Hipp wrote: > sqlite3_column_table_name() (and all of the other METADATA functions) only > work on table columns, not on functions. The documentation says as much, > though perhaps it could be worded more directly. I'll make a note to clarify > the documentatio

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread Rob Sciuk
On Mon, 26 Oct 2009, Jay A. Kreibich wrote: > The documentation on this is fairly clear: > > http://sqlite.org/c3ref/column_database_name.html > > If the Nth column returned by the statement is an expression or > subquery and is not a column value, then all of these functions >

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread D. Richard Hipp
On Oct 26, 2009, at 5:28 PM, Rob Sciuk wrote: > > I've just compiled the latest (3.6.19) with the > > -DSQLITE_ENABLE_COLUMN_METADATA flag set. The problem I'm seeing is > that > when I use an aggregate function in a select, the table name is not > being > returned from an sqlite3_column_tab

Re: [sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread Jay A. Kreibich
On Mon, Oct 26, 2009 at 05:28:50PM -0400, Rob Sciuk scratched on the wall: > > I've just compiled the latest (3.6.19) with the > > -DSQLITE_ENABLE_COLUMN_METADATA flag set. The problem I'm seeing is that > when I use an aggregate function in a select, the table name is not being > returned fro

[sqlite] SQLITE_ENABLE_COLUMN_METADATA question ...

2009-10-26 Thread Rob Sciuk
I've just compiled the latest (3.6.19) with the -DSQLITE_ENABLE_COLUMN_METADATA flag set. The problem I'm seeing is that when I use an aggregate function in a select, the table name is not being returned from an sqlite3_column_table_name() is not returning the tablename as expected from a pre