I've met the same problem and I'll really appreciate, if this feature
starts to work. Maybe I've also missed something in doc.
Fanda
On Wed, 06 Dec 2006 02:45:30 +0100, Sandeep Suresh <[EMAIL PROTECTED]>
wrote:
When doing a select with join as :
select * from table_1
left join table_2
on
M +1100, John Stanton wrote:
PostgreSQL implements standard SQL as well as the features of an
enterprise DBMS. On that basis if you are changing it makes sense to
change to the fuller-featured product, one in the same class as Oracle
and DB2. In the short term Mysql could be as good as PostgreSQ
I'm not sure, if Postgres is better choice than MySQL. I have used both of
them to find out which is the better one. Both of them can do almost
anything. The choice is a matter of taste and person. We are free to
choose:)) I'm talking about MySQL 5 and PostgreSQL 8.1.
Sorry for writing this
If you parse such a simple query like
SELECT [*,] bla [, bla] FROM table-name WHERE blabla ,
you'll get into less troubles than if you play with the rowid trick. All
you need is to check if returned colnames can be found in table-name. And
it is a simple question using PRAGMA table_info(tabl
Hi,
it seems, that ver 2.3.7 does not report the column names properly if one
use joined select. Documntation says:
... Normally, such result columns are named
. if the SELECT statement joins two or more
tables together, or simply if the SELECT statement queries a
single table. ...
b
Try 'make doc' :))
Fanda
--- Forwarded message ---
From: "Firman Wandayandi" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org, [EMAIL PROTECTED]
Cc:
Subject: Re: [sqlite] SQLITE Documentation
Date: Mon, 12 Sep 2005 10:08:36 +0200
On 9/12/05, ShepherdHill DB Subscriptions
<[EMAIL PROTECTED
(zName));
continue;
--- Forwarded message ---
From: "Fanda Vacek" <[EMAIL PROTECTED]>
To: "sqlite-users@sqlite.org"
Cc:
Subject: [sqlite] pragma full_column_names
Date: Wed, 10 Aug 2005 13:23:43 +0200
Hi,
does the pragma full_column_names work in sqlite3 co
Hi,
does the pragma full_column_names work in sqlite3 command line utility?
If I write:
.header on
pragma full_column_names=1;
select * from t1;
I do not see the table name (t1) in column headers. I see 'ID' not 't1.ID'.
Fanda
Hi,
I need very much function
const char *sqlite3_column_database_name(sqlite3_stmt *pStmt, int N),
where it is supposed to be a part of C API?
fanda
9 matches
Mail list logo
