For column "xxx" what will the full column name be? "foo.xxx"? Doug
> -----Original Message----- > From: sqlite-users <[email protected]> > On Behalf Of Simon Slavin > Sent: Tuesday, December 10, 2019 10:37 AM > To: SQLite mailing list <[email protected]> > Subject: Re: [sqlite] Result set column names > > On 10 Dec 2019, at 5:13pm, Doug <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
