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]
