For column "xxx" what will the full column name be? "foo.xxx"? Doug
> -----Original Message----- > From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> > On Behalf Of Simon Slavin > Sent: Tuesday, December 10, 2019 10:37 AM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] Result set column names > > On 10 Dec 2019, at 5:13pm, Doug <dougf....@comcast.net> wrote: > > > Just to be clear: If I define a column in a table named "xxx", > and I "select xxx from table", the report will show a column named > "xxx" always. That's what the standard says, right? It's not > implementation dependent, right? > > Unless you have specified another column "AS xxx", or used "PRAGMA > full_column_names". > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
