Richard, can't you make it user configurable? I was serious about the PRAGMA. Would be nice if it could be persistent as well as single instance.
With user configuration many could configure around the issue on older code and take the default (is it not an SQL standard? I've never had occasion until now to look.) with new stuff. I've been mentally reviewing my twenty plus year history with SQL and I can never recall using any database that appended the table designator on the fields returned. SQLite is one of the sweetest little databases I have ever used, it is a pity that there are a few innocent seeming issues that can prove to be serious roadblocks. I think based on the product of your work so far, you will certainly find a workable answer for this one, and the storage issue related to database "cleansing." Fred -----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 7:12 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Select statements returned column names Gerard Samuel wrote: > > If I execute an sql select like -> > SELECT f.id, f.foo FROM table f; > The returned data is -> > f.id f.foo > 1 hello > 2 world > > Instead of the normal (as in other DBs I've used) > id foo > 1 hello > 2 world > > Is this the correct/expected behaviour of sqlite? You can always specify your own column names using an AS clause, of source: SELECT f.id AS one, f.foo AS two FROM table f; one two 1 hello 2 world SQLite does attach "different" names to the columns than other database engines. This has been a persistent source of complaint. The problem comes up on joins more than anyplace else. Question to all: If I modified SQLite to use the same column naming rules as (say) PostgreSQL, how much existing code would it break? Is this something that should be done, even though it is a (slightly) incompatible change? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
